protected void btnAdd_Click(object sender, EventArgs e)
{
_Branch b = new _Branch(txtLocation.Text, Convert.ToInt32(ddlBranchOwner.SelectedValue));
SQLManager.SQLAddBranch(b);
ClearData();
}
public object Select_Branch(int num, string Company, string BranchCode, string BranchName)
{
object result = null;
CStatementList cstate = new CStatementList(_SQLConnection.CSQLConnection);
try
{
try
{
CSQLParameterList plist = new CSQLParameterList();
plist.Add("@num", DbType.Int32, num, ParameterDirection.Input);
plist.Add("@Company", DbType.String, Company, ParameterDirection.Input);
plist.Add("@BranchCode", DbType.String, BranchCode, ParameterDirection.Input);
plist.Add("@BranchName", DbType.String, BranchName, ParameterDirection.Input);
CSQLDataAdepterList adlist = new CSQLDataAdepterList();
CSQLStatementValue csv = new CSQLStatementValue(this._statementB, plist, NoomLibrary.StatementType.Select);
adlist.Add(csv);
cstate.Open();
result = cstate.Execute(adlist);
DataTable dt = (DataTable)result;
foreach (DataRow item in dt.Rows)
{
int id = int.Parse(item["ID"].ToString());
_Branch _b = new _Branch();
_b._Company.Companycode = item["Company"].ToString();
_b.Branchcode = item["Branch"].ToString();
_b.BranchName = item["BranchName"].ToString();
this.Add(id, _b);
}
cstate.Commit();
}
catch (SqlException)
{
cstate.Rollback();
throw;
}
finally
{
cstate.Close();
}
}
catch (Exception)
{
throw;
}
return(result);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
_AdminUser au;
_Branch b;
char sex = 'x';
int lastID = 1;
if (rblSex.SelectedValue == "Male")
{
sex = 'M';
}
else if (rblSex.SelectedValue == "Female")
{
sex = 'F';
}
if (txtEmail.Text != "" && txtFirst.Text != "" && txtLast.Text != "" && txtMiddle.Text != "" && txtMobileNo.Text != "" && txtPass.Text != "" && txtRePass.Text != "" && txtUsername.Text != "" && sex == 'M' || sex == 'F')
{
if (picUpload.HasFile)
{
lastID += SQLManager.SQLLastID();
string strname = picUpload.FileName.ToString();
string ext = Path.GetExtension(strname).ToLower();
if (ext == ".jpeg" || ext == ".jpg" || ext == ".gif" || ext == ".png")
{
picUpload.PostedFile.SaveAs(Server.MapPath("/images/users/") + lastID + ext);
}
}
au = new _AdminUser(txtLast.Text, txtFirst.Text, txtMiddle.Text, txtMobileNo.Text, txtEmail.Text, txtUsername.Text, txtPass.Text, "Branch Manager", sex);
b = new _Branch(lastID++);
SQLManager.SQLAdd(au);
SQLManager.SQLAddBranchManager(b);
Clear();
}
}
public void GetChecked(string msg)
{
int reqID;
int id = 0;
int userID = 0;
string loc = "";
string cityCode = "";
int years = 0;
int branchCtr = 0;
string branchID = "";
foreach (GridViewRow gvrow in gvRequests.Rows)
{
CheckBox chk = (CheckBox)gvrow.FindControl("cbSelect");
if (chk != null && chk.Checked)
{
reqID = Convert.ToInt32(gvrow.Cells[1].Text);
var cs = ConfigurationManager.ConnectionStrings["ZoomDB"];
string connection = cs.ConnectionString;
SqlConnection sqlconnect = new SqlConnection(connection);
SqlDataAdapter adapt = new SqlDataAdapter("Select * from ReqStatFranch", sqlconnect);
DataSet dsReq = new DataSet();
adapt.Fill(dsReq, "ReqStatFranch");
DataTable tblReq;
tblReq = dsReq.Tables["ReqStatFranch"];
foreach (DataRow row in tblReq.Rows)
{
if (reqID == Convert.ToInt32(row["id"].ToString()))
{
userID = Convert.ToInt32(row["userid"].ToString());
loc = row["location"].ToString();
cityCode = row["cityCode"].ToString();
years = Convert.ToInt32(row["years"].ToString());
break;
}
}
adapt = new SqlDataAdapter("Select * from citytown", sqlconnect);
dsReq = new DataSet();
adapt.Fill(dsReq, "citytown");
tblReq = dsReq.Tables["citytown"];
foreach (DataRow row in tblReq.Rows)
{
if (cityCode == row["Code"].ToString())
{
branchCtr = Convert.ToInt32(row["Branches"].ToString());
break;
}
}
//*****************************COMMANDS TO UPDATE CUSTOMER TO OWNER && ADDING TO BRANCH TABLE
branchID = cityCode + "-" + (branchCtr + 1).ToString();
SQLManager.SQLUpdateCustToOwner(userID);
_Branch B = new _Branch(loc, userID, branchID, cityCode);
SQLManager.SQLAddBranch(B);
SQLManager.SQLUpdateCityCtr(branchCtr, cityCode);
//*********************************ADD TO FRANCHISE TABLE
adapt = new SqlDataAdapter("Select * from branch", sqlconnect);
dsReq = new DataSet();
adapt.Fill(dsReq, "branch");
tblReq = dsReq.Tables["branch"];
foreach (DataRow row in tblReq.Rows)
{
if (branchID == row["branchID"].ToString())
{
id = Convert.ToInt32(row["id"].ToString());
break;
}
}
sqlconnect.Close();
DateTime start = DateTime.Now;
DateTime end = start.AddYears(years);
_Franchise F = new _Franchise(id, start, end);
SQLManager.SQLAddFranchise(F);
SQLManager.DeleteReqStat(reqID);
SQLManager.SQLAddNotif(msg, userID);
}
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
_AdminUser au;
_Branch b;
char sex = 'x';
int lastID = 1;
if (rblSex.SelectedValue == "Male")
{
sex = 'M';
}
else if (rblSex.SelectedValue == "Female")
{
sex = 'F';
}
if (txtEmail.Text != "" && txtFirst.Text != "" && txtLast.Text != "" && txtMiddle.Text != "" && txtMobileNo.Text != "" && txtPass.Text != "" && txtRePass.Text != "" && txtUsername.Text != "" && sex == 'M' || sex == 'F')
{
if (picUpload.HasFile)
{
lastID += SQLManager.SQLLastID();
string strname = picUpload.FileName.ToString();
string ext = Path.GetExtension(strname).ToLower();
if (ext == ".jpeg" || ext == ".jpg" || ext == ".gif" || ext == ".png")
{
picUpload.PostedFile.SaveAs(Server.MapPath("/images/users/") + lastID + ext);
}
}
au = new _AdminUser(txtLast.Text, txtFirst.Text, txtMiddle.Text, txtMobileNo.Text, txtEmail.Text, txtUsername.Text, txtPass.Text, "Branch Manager", sex);
b = new _Branch(lastID++);
SQLManager.SQLAdd(au);
int uID = Convert.ToInt32(Session["ID"]);
string location = ddlAssign.SelectedItem.ToString();
int bID = -1;
var cs = ConfigurationManager.ConnectionStrings["ZoomDB"];
string connection = cs.ConnectionString;
SqlConnection sqlconnect = new SqlConnection(connection);
SqlDataAdapter adapt = new SqlDataAdapter("Select * from BRANCH", sqlconnect);
DataSet dsReq = new DataSet();
adapt.Fill(dsReq, "BRANCH");
DataTable tblReq;
tblReq = dsReq.Tables["BRANCH"];
foreach (DataRow row in tblReq.Rows)
{
if ((location == row["location"].ToString()) && (uID == Convert.ToInt32(row["BR_OWNERID"].ToString())))
{
bID = Convert.ToInt32(row["id"].ToString());
break;
}
}
SQLManager.SQLAddBranchManager(b, bID);
Clear();
}
}
