protected void saveButton_Click(object sender, EventArgs e) { CenterCreate aCenterCreate = new CenterCreate(); ShowCenterUI aShowCenterUi = new ShowCenterUI(); aCenterCreate.Name = centerNameTextBox.Text; string thana = thanaDropDownList.SelectedItem.ToString(); aCenterCreate.ThanaID = aCenterCreateManager.GetIDByThanaName(thana); aCenterCreate.DistrictID = aCenterCreateManager.GetDistrictIDByThanaName(thana); aCenterCreate.Code = GenerateCode(thana); aCenterCreate.Password = CreateRandomPassword(); if (aCenterCreate.Name != "") { showLabel.Text = aCenterCreateManager.Save(aCenterCreate); Session["Name"] = centerNameTextBox.Text; Session["Code"] = aCenterCreate.Code; Session["Password"] = aCenterCreate.Password; Response.Redirect("ShowCenterUI.aspx"); } else { showLabel.Text = "Not saved. Please enter information correctly."; } }
public string Save(CenterCreate aCenterCreate) { if (aCenterCreateGateway.Save(aCenterCreate) > 0) { return "Data saved Sccessfully."; } else { return "Data not saved."; } }
public List<CenterCreate> CenterList(string thana) { int thanaID = GetThanaIDByThana(thana); SqlConnection connection = new SqlConnection(connectionstring); string query = "select * from tbl_CenterCreate where ThanaID = '"+thanaID+"'"; SqlCommand command = new SqlCommand(query,connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); List<CenterCreate> centerList = new List<CenterCreate>(); while (reader.Read()) { CenterCreate aCenterCreate = new CenterCreate(); aCenterCreate.ID = int.Parse(reader["ID"].ToString()); aCenterCreate.Name = reader["Name"].ToString(); centerList.Add(aCenterCreate); } reader.Close(); connection.Close(); return centerList; }
public int Save(CenterCreate aCenterCreate) { SqlConnection connection = new SqlConnection(connectionstring); string query = "insert into tbl_CenterCreate values ('" + aCenterCreate.Name + "','" + aCenterCreate.ThanaID + "','" + aCenterCreate.DistrictID + "','" + aCenterCreate.Code + "','" + aCenterCreate.Password + "')"; SqlCommand command = new SqlCommand(query,connection); connection.Open(); int rowAffected = command.ExecuteNonQuery(); connection.Close(); return rowAffected; }