private void setData()
{
Edit_Info master = (Edit_Info)this.Master;
Label LabelACNO = (Label)master.FindControl("LabelACNO");
TextBox TextBoxName = (TextBox)master.FindControl("TextBoxName");
TextBox TextBoxDOB = (TextBox)master.FindControl("TextBoxDOB");
TextBox TextBoxNIDNo = (TextBox)master.FindControl("TextBoxNIDNo");
TextBox TextBoxPhone = (TextBox)master.FindControl("TextBoxPhone");
TextBox TextBoxAddress = (TextBox)master.FindControl("TextBoxAddress");
TextBox TextBoxEmail = (TextBox)master.FindControl("TextBoxEmail");
LoadDB("Admin", "AdminId", 2000, 1);
SqlDataAdapter adapter = (SqlDataAdapter)Cache["Adapter"];
DataSet ds = (DataSet)Cache["DataSet"];
DataRow[] dr = ds.Tables["Admin"].Select("AdminId = 2000");
int status = 2000;
foreach (DataRow row in dr)
{
if (status.Equals(row["AdminId"]))
{
LabelACNO.Text = row["AdminId"].ToString();
TextBoxName.Text = row["Name"].ToString();
TextBoxDOB.Text = row["DOB"].ToString();
TextBoxNIDNo.Text = row["NIDNO"].ToString();
TextBoxPhone.Text = row["Phone"].ToString();
TextBoxAddress.Text = row["Address"].ToString();
TextBoxEmail.Text = row["Email"].ToString();//Session["UserId"];
}
}
Cache["Dataset"] = ds;
}
private void setData()
{
Edit_Info master = (Edit_Info)this.Master;
Label LabelACNO = (Label)master.FindControl("LabelACNO");
TextBox TextBoxName = (TextBox)master.FindControl("TextBoxName");
TextBox TextBoxDOB = (TextBox)master.FindControl("TextBoxDOB");
TextBox TextBoxNIDNo = (TextBox)master.FindControl("TextBoxNIDNo");
TextBox TextBoxPhone = (TextBox)master.FindControl("TextBoxPhone");
TextBox TextBoxAddress = (TextBox)master.FindControl("TextBoxAddress");
TextBox TextBoxEmail = (TextBox)master.FindControl("TextBoxEmail");
LoadDB("Customer", "CustomerId", 10000000, 1);
SqlDataAdapter adapter = (SqlDataAdapter)Cache["Adapter"];
DataSet ds = (DataSet)Cache["DataSet"];
DataRow[] row = ds.Tables["Customer"].Select("CustomerId = 10000000");
int status = 10000000;
foreach (DataRow dr in row)
{
if (status.Equals(dr["CustomerId"]))
{
LabelACNO.Text = dr["CustomerId"].ToString();
TextBoxName.Text = dr["CustomerName"].ToString();
TextBoxDOB.Text = dr["DOB"].ToString();
TextBoxNIDNo.Text = dr["NIDNO"].ToString();
TextBoxPhone.Text = dr["Phone"].ToString();
TextBoxAddress.Text = dr["Address"].ToString();
TextBoxNomName.Text = dr["NominyName"].ToString();
TextBoxNomDOB.Text = dr["NominyDOB"].ToString();
TextBoxNomNIDNo.Text = dr["NominyNIDNO"].ToString();
TextBoxNomPhone.Text = dr["NominyPhone"].ToString();
TextBoxNomAddress.Text = dr["NominyAddress"].ToString();
TextBoxNomEmail.Text = dr["NominyEmail"].ToString();
}
}
Cache["Dataset"] = ds;
}
/* private void UpdateDB()
* {
* LoadDB("BankStatus", "StatusId", 1, 1);
* SqlDataAdapter adapter = (SqlDataAdapter)Cache["Adapter"];
* DataSet ds = (DataSet)Cache["DataSet"];
* DataRow[] dr = ds.Tables["BankStatus"].Select("StatusId = '1'");
* int status = 1;
* foreach (DataRow row in dr)
* {
* if (status.Equals(row["StatusId"]))
* {
* row["LoanStatus"] = TextBoxLoanStatus.Text;
* row["Notice"] = TextBoxNotice.Text;
* }
* }
* Cache["Dataset"] = ds;
* ds = (DataSet)Cache["DataSet"];
* adapter = (SqlDataAdapter)Cache["Adapter"];
* adapter.Update(ds.Tables["BankStatus"]);
* }*/
private void UpdateDB()
{
Edit_Info master = (Edit_Info)this.Master;
TextBox TextBoxName = (TextBox)master.FindControl("TextBoxName");
TextBox TextBoxDOB = (TextBox)master.FindControl("TextBoxDOB");
TextBox TextBoxNIDNo = (TextBox)master.FindControl("TextBoxNIDNo");
TextBox TextBoxPhone = (TextBox)master.FindControl("TextBoxPhone");
TextBox TextBoxAddress = (TextBox)master.FindControl("TextBoxAddress");
TextBox TextBoxEmail = (TextBox)master.FindControl("TextBoxEmail");
RadioButtonList RadioButtonListGender = (RadioButtonList)master.FindControl("RadioButtonListGender");
RadioButtonList RadioButtonListNIDType = (RadioButtonList)master.FindControl("RadioButtonListNIDType");
FileUpload fileup = (FileUpload)master.FindControl("FileUploadProPic");
Label fileErr = (Label)master.FindControl("FileErr");
string fileEx = System.IO.Path.GetExtension(fileup.FileName);
string name = TextBoxName.Text + TextBoxPhone.Text;
string filePath = Server.MapPath("~/Images/ProPic/" + name + fileEx);
if (fileup.HasFile)
{
if (fileEx.ToLower() != ".jpeg" && fileEx.ToLower() != ".jpg" && fileEx.ToLower() != ".png")
{
fileErr.Text = "Only .jpeg, .jpg and .png file is allowed";
}
else
{
int filesize = fileup.PostedFile.ContentLength;
if (filesize > 4194304)
{
fileErr.Text = "File should be less than 4mb";
}
else
{
fileup.SaveAs(filePath);
}
}
}
LoadDB("Admin", "AdminId", 2000, 1);
SqlDataAdapter adapter = (SqlDataAdapter)Cache["Adapter"];
DataSet ds = (DataSet)Cache["DataSet"];
// DataRow dr =new DataRow( ds.Tables["Admin"]);
// dr["ChangeId"] = "400001";
DataRow[] row = ds.Tables["Admin"].Select("AdminId = 2000");
int status = 2000;
foreach (DataRow dr in row)
{
if (status.Equals(dr["AdminId"]))
{
dr["Name"] = TextBoxName.Text;
dr["DOB"] = TextBoxDOB.Text; //Session["UserId"];
dr["Gender"] = RadioButtonListGender.SelectedValue; //Session["UserName"];
dr["NIDNO"] = TextBoxNIDNo.Text;
dr["NIDType"] = RadioButtonListNIDType.SelectedValue;
dr["Phone"] = TextBoxPhone.Text;
dr["Address"] = TextBoxAddress.Text; //Session["UserId"];
dr["Email"] = TextBoxEmail.Text; //Session["UserName"];
dr["ProPic"] = "~/Images/ProPic/" + name + fileEx;
Cache["Dataset"] = ds;
ds = (DataSet)Cache["DataSet"];
adapter = (SqlDataAdapter)Cache["Adapter"];
adapter.Update(ds.Tables["Admin"]);
}
}
}