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();
}
}
}
}
}
}
}
