public int MarkAttendance(int empid, int shift) { var context = new ubietydbEntities(); Attendance attendance = new Attendance(); attendance.EmpId = empid; attendance.MarkFlagId = shift; attendance.MarkTime = TimeZoneInfo.ConvertTime(new DateTime(DateTime.Now.Ticks), TimeZoneInfo.FindSystemTimeZoneById("India Standard Time")); context.Attendances.Add(attendance); return context.SaveChanges(); }
protected void Page_Load(object sender, EventArgs e) { var context = new ubietydbEntities(); Attendance attendance = new Attendance(); attendance.EmpId = Convert.ToInt16(Request.Form["empid"]); attendance.MarkFlagId = 1; attendance.MarkTime = TimeZoneInfo.ConvertTime(new DateTime(DateTime.Now.Ticks), TimeZoneInfo.FindSystemTimeZoneById("india standard time")); attendance.latitude = Convert.ToDouble(Request.Form["latitude"]); attendance.longitude = Convert.ToDouble(Request.Form["longitude"]); attendance.markcount = Convert.ToInt16(Request.Form["count"]); context.Attendances.Add(attendance); if (context.SaveChanges() == 1) { //HttpClient client = new HttpClient(); //client.GetAsync(new Uri("http://ubietyapi.azurewebsites.net/api/attendance/punch/1/1/1.2/2.1/-1")); CloudStorageAccount storageAccount = CloudStorageAccount.Parse(CloudConfigurationManager.GetSetting("StorageConnectionString")); CloudBlobClient blobClient = storageAccount.CreateCloudBlobClient(); CloudBlobContainer container = blobClient.GetContainerReference("ubiety"); container.CreateIfNotExists(); container.SetPermissions(new BlobContainerPermissions { PublicAccess = BlobContainerPublicAccessType.Blob }); DateTime IST = TimeZoneInfo.ConvertTime(new DateTime(DateTime.Now.Ticks), TimeZoneInfo.FindSystemTimeZoneById("India Standard Time")); String blobName = Request.Form["name"] + "/" + IST.ToString("yyyy") + "/" + IST.ToString("MM") + "/" + IST.ToString("dd") + "/" + Request.Form["count"].ToString(); CloudBlockBlob blockBlob = container.GetBlockBlobReference(blobName); blockBlob.UploadFromStream(Request.Files[0].InputStream); } //if (blockBlob.Exists()) //{ // blockBlob = container.GetBlockBlobReference(blobName.Replace("/AM", "/PM")); //} //if (!blockBlob.Exists()) //{ // blockBlob.Metadata.Add("Latitude", Request.Form["latitude"]); // blockBlob.Metadata.Add("Longitude", Request.Form["longitude"]); // blockBlob.UploadFromStream(Request.Files[0].InputStream); //} }
public int MarkAttendanceWithLatLon(int empid, int shift, Double latitude, Double longitude, Int16 markcount) { var context = new ubietydbEntities(); Attendance attendance = new Attendance(); attendance.EmpId = empid; attendance.MarkFlagId = shift; attendance.MarkTime = TimeZoneInfo.ConvertTime(new DateTime(DateTime.Now.Ticks), TimeZoneInfo.FindSystemTimeZoneById("India Standard Time")); attendance.latitude = latitude; attendance.longitude = longitude; attendance.markcount = markcount; context.Attendances.Add(attendance); return context.SaveChanges(); }