Sunday, October 20, 2019

Export Table to other Server: SQL SERVER


STEP 1: Right Click on Source database. Here you will see some Options. 

  Click on Export data.

STEP 2: A wizard will open. click on next button.


STEP 3:  Here the Source Of data need to choose. Give the credentials and select the database.


STEP 4: Continued of step 3. Choose the Source database.



STEP 5: In this step you have to choose the destination database. Give the credentials and select the database.


STEP 6: In this step the table need to choose. From which the data will be transfer. Notice the right side is the table name which will be on the destination server.




STEP 7: Keep Click on next.



STEP 8: Here the process will be started.


STEP 9: After the process is done this screen will be showed. click on close.


Now go to the destination database server. Execute: Select * FROM theTableName

Wednesday, October 2, 2019

My Work::KHALID

: Xamarin App Development
: R&D on new technologies
: File Management Systems
: gHRM New Features ; Rich text box, New Reports , Process on sql server side.
: gBanker : R&D: Add rich text Box, Using Ajax: On Select Member Show Photo and Signature.
: SMS: gHRM and gBanker New Module.
: Voice Data collection : Hisab.
: gHRM plus Attendence system and Time Picker add.
: digital signature add. Canvas to Crystal report.

Monday, September 30, 2019

Show image using ajax call



I created a service to get member information using entity framework.

then i used the service like this.

 [HttpGet]
        public JsonResult GetMemberImageData(string MemberId)
        {
            try
            {
  var memberPhoto = memberService.GetById(Convert.ToInt32(MemberId));

MemberViewModel myMember = new MemberViewModel();
myMember.MemberCode = Convert.ToBase64String( memberPhoto.MemberImg );

 List<MemberViewModel> List_ViewModel = new List<MemberViewModel>();

                List_ViewModel.Add(myMember);


  return Json(List_ViewModel.ToList(), JsonRequestBehavior.AllowGet);
            }
            catch (Exception ex)
            { return Json(ex.ToString(), JsonRequestBehavior.AllowGet); }

        }



in view:  .cshtml file::
function GetMemberPhotoSignature(member)
    {
        //alert(member);

         $.ajax({
            type: 'GET',
            contentType: "application/json; charset=utf-8",
            url: '@Url.Action("GetMemberImageData", "SpecialSavingCollection", "http")',
             data: { MemberId: member },
            dataType: 'json',
            async: true,
            success: function (data) {
                $('#AjaxLoader').hide();
                $.each(data, function (index, data) {
                    if (data != "Error") {
                        alert(data.MemberCode);
                        $("#target").attr("src", "data:image/gif;base64, " + data.MemberCode);
                            //$("#EmployeeID").val(data.EmployeeID);
                    }
                    else {
                       
                       // $("#EmployeeName").val('');
                    }
                });
            },
            error: function (request, status, error) {
                $('#AjaxLoader').hide();
             
               // $.alert.open("Employee Does Not Exist");
            }
        });




HTML::
<img id="target" src="data:image/png;base64, iVBORw0KGgoAAAANSUhEUgAAAAUA
 AAAFCAYAAACNbyblAAAAHElEQVQI12P4//8/w38GIAXDIBKE0DHxgljNBAAO
 9TXL0Y4OHwAAAABJRU5ErkJggg==" alt="Red dot" />






Monday, August 26, 2019

Debug on physical Device. Android Xamarin

I tried and tried. Keep searching.. Tried many ways... But there is always a perfect solution...Need to find that.



I did every thing. setup my android phone on

1.developer mode.

2. enable usb debugger.



etc.



But there was a problem on my laptop. The adb interface( Control panel-> device manager-> other devices-> adb interface) was not correctly installed(yellow marking).



Then I searched for it found https://adb.clockworkmod.com/ .

Download and install. But for perfection you can uninstall the previous adb interface.








Friday, July 19, 2019

There were deployment errors : XAMARIN


This error occurs for mis-configuration of Application.
Make sure you have configured sdk correctly. Tools-> Option-> Xamarin (Give the right path of jdk)


Right click on your project. -> properties -> Android Options-> check Use share Runtime. Uncheck Use Fast Deployment(debug mode only).


Right click on your project. -> properties -> Application-> set the right version of Android sdk and your emulators Android sdk  from dropdown


It should solve your errors.

Screen Record

 Windows Screen Record WindowsKey+ Alt + R Recording Starts.