protected void btnGo_Click(object sender, EventArgs e) { var fileName = flData.FileName; var fileContentType = flData.PostedFile.ContentType; var pathUploaded = Uploader.FileUploader(flData.PostedFile); var connectionString = Uploader.GetExcelConnectionString(fileContentType, pathUploaded); OleDbConnection OleCon = new OleDbConnection(connectionString); DataTable tbl = new DataTable("MyTable"); OleCon.Open(); var tableName = OleCon.GetSchema("Tables").Rows[0]["TABLE_NAME"]; OleDbCommand OleCmd = new OleDbCommand(string.Format("Select * from [{0}]", tableName), OleCon); OleDbDataAdapter adp = new OleDbDataAdapter(OleCmd); adp.Fill(tbl); using (VallabaiDataContext db = new VallabaiDataContext()) { foreach (DataRow row in tbl.Rows) { var OldRegID = Convert.ToString(row.ItemArray[0]); var Code = OldRegID; var Name = Convert.ToString(row.ItemArray[1]); var FatherName = Convert.ToString(row.ItemArray[2]); var Address = Convert.ToString(row.ItemArray[3]); var Age = Convert.ToString(row.ItemArray[4]); var MalaiDetail = Convert.ToString(row.ItemArray[5]); var MalaiCount = 0; if (MalaiDetail != "") { MalaiCount = 0; } else if (MalaiDetail == "KANNI") { MalaiCount = 1; } else { MalaiCount = Convert.ToInt32(MalaiDetail); } var MobileNumber = Convert.ToString(row.ItemArray[6]); var Membership = Convert.ToString(row.ItemArray[10]); var IsMember = false; if (Membership != "") { IsMember = true; } tab_VA_SWAMY_REGISTRATION reg = new tab_VA_SWAMY_REGISTRATION(); try { reg.swamy_CODE = Code; reg.swamy_OLD_REG_NUMBER = OldRegID; reg.swamy_NAME = Name; reg.swamy_FATHER_SPOUSE_NAME = FatherName; reg.swamy_GENDER = "Male"; reg.swamy_IS_MEMBER = IsMember; reg.swamy_PLACE = Address; reg.swamy_ADDRESS = Address; reg.swamy_MOBILE_NUMBER = MobileNumber; reg.swamy_DISTRICT = "Ramanathapuram"; reg.swamy_MALAI_VISIT = MalaiCount; reg.swamy_MEMBERSHIP_TYPE = Membership; db.tab_VA_SWAMY_REGISTRATIONs.InsertOnSubmit(reg); db.SubmitChanges(); } catch (Exception ex) { Response.Write(ex.Message); } } Response.Write("Upload Completed"); } }
protected void btnSave_Click(object sender, EventArgs e) { if (Page.IsValid) { var SwamyName = txtName.Text; var SwamyFatherName = txtFatherName.Text; var SwamyGender = string.Empty; if (rdlSwamy.Checked) { SwamyGender = rdlSwamy.Value; } else { SwamyGender = rdlMaaligaipuram.Value; } var SwamyDOB = string.Empty; if (Utilities.isValidDate(txtDOB.Text)) { SwamyDOB = txtDOB.Text; } var SwamyMobileNumber = txtMobileNumber.Text; var SwamyAlternateMobile = txtAlternateMobile.Text; var SwamyPlace = txtPlace.Text; var SwamyAddress = txtAddress.Text; var SwamyDistrict = ddlDistrict.SelectedValue; var SwamyBloodGroup = ddlBloodGroup.SelectedValue; var SwamyMalaiVisit = 0; if (Utilities.isNumber(txtMalai.Text)) { SwamyMalaiVisit = Convert.ToInt32(txtMalai.Text); } var SwamyKanniPoojaiDate = string.Empty; if (Utilities.isValidDate(txtKanniPoojaiDate.Text)) { SwamyKanniPoojaiDate = txtKanniPoojaiDate.Text; } var SwamyMemebershipExpiry = string.Empty; if (Utilities.isValidDate(txtMembershipExpiry.Text)) { SwamyMemebershipExpiry = txtMembershipExpiry.Text; } var SwamyMembership = string.Empty; if (rdlNonMeber.Checked) { SwamyMembership = rdlNonMeber.Value; } else if (rdlLifetime.Checked) { SwamyMembership = rdlLifetime.Value; } else { SwamyMembership = rdlShortTermMember.Value; } //Get Swamy Code if (btnSave.Text == "Save") { var SwamyCode = Utilities.GetSwamyCode(); using (VallabaiDataContext db = new VallabaiDataContext()) { tab_VA_SWAMY_REGISTRATION regis = new tab_VA_SWAMY_REGISTRATION(); regis.swamy_CODE = SwamyCode; regis.swamy_NAME = SwamyName; regis.swamy_FATHER_SPOUSE_NAME = SwamyFatherName; regis.swamy_GENDER = SwamyGender; if (!string.IsNullOrEmpty(SwamyDOB)) { regis.swamy_DOB = Convert.ToDateTime(SwamyDOB); } regis.swamy_PLACE = SwamyPlace; regis.swamy_ADDRESS = SwamyAddress; regis.swamy_MOBILE_NUMBER = SwamyMobileNumber; regis.swamy_ALTERNATE_MOBILE = SwamyAlternateMobile; regis.swamy_DISTRICT = SwamyDistrict; regis.swamy_BLOOD_GROUP = SwamyBloodGroup; regis.swamy_MALAI_VISIT = SwamyMalaiVisit; if (!string.IsNullOrEmpty(SwamyKanniPoojaiDate)) { regis.swamy_KANNI_POOJAI_DATE = Convert.ToDateTime(SwamyKanniPoojaiDate); } //regis.swamy_IS_MEMBER = regis.swamy_MEMBERSHIP_TYPE = SwamyMembership; if (!string.IsNullOrEmpty(SwamyMemebershipExpiry)) { regis.swamy_MEMBERSHIP_EXPIRY_DATE = Convert.ToDateTime(SwamyMemebershipExpiry); } db.tab_VA_SWAMY_REGISTRATIONs.InsertOnSubmit(regis); db.SubmitChanges(); var SwamyID = Utilities.GetLatestRegisterID(); //Save The Photo against the Swamy if (flPhoto.PostedFiles != null) { if (flPhoto.PostedFile.ContentLength > 0) { flPhoto.PostedFile.SaveAs(Server.MapPath("~/management/Resources/temp/" + SwamyID + ".jpg")); } } Page.ClientScript.RegisterStartupScript(this.GetType(), "ShowStatus", "$(function() { funShowMessage('User Details updated successfully')});", true); ClearFields(); } } else { if (Request.QueryString["sid"] != null) { var SwamyID = Convert.ToInt32(Ciphering.Decrypt(Convert.ToString(Request.QueryString["sid"]))); using (VallabaiDataContext db = new VallabaiDataContext()) { var swamy = from s in db.tab_VA_SWAMY_REGISTRATIONs where s.swamy_ID == SwamyID select s; if (swamy.Count() > 0) { foreach (var regis in swamy) { regis.swamy_NAME = SwamyName; regis.swamy_FATHER_SPOUSE_NAME = SwamyFatherName; if (!string.IsNullOrEmpty(SwamyDOB)) { regis.swamy_DOB = Convert.ToDateTime(SwamyDOB); } regis.swamy_MOBILE_NUMBER = SwamyMobileNumber; regis.swamy_ALTERNATE_MOBILE = SwamyAlternateMobile; regis.swamy_PLACE = SwamyPlace; regis.swamy_ADDRESS = SwamyAddress; regis.swamy_DISTRICT = SwamyDistrict; regis.swamy_BLOOD_GROUP = SwamyBloodGroup; regis.swamy_MALAI_VISIT = SwamyMalaiVisit; regis.swamy_MEMBERSHIP_TYPE = SwamyMembership; if (!string.IsNullOrEmpty(SwamyMemebershipExpiry)) { regis.swamy_MEMBERSHIP_EXPIRY_DATE = Convert.ToDateTime(SwamyMemebershipExpiry); } if (flPhoto.PostedFiles != null) { if (flPhoto.PostedFile.ContentLength > 0) { flPhoto.PostedFile.SaveAs(Server.MapPath("~/management/Resources/temp/" + SwamyID + ".jpg")); } } db.SubmitChanges(); Page.ClientScript.RegisterStartupScript(this.GetType(), "ShowStatus", "$(function() { funShowMessage('User Details updated successfully')});", true); ClearFields(); } } } } } } }