public static void SetBAddr(DataRow bAddr) { String connString = Properties.Settings.Default.FAFOS; SqlConnection con = new SqlConnection(connString); SqlCommand BAddrsCommand; MFranchise f = new MFranchise(); if (bAddr["locID"].ToString() == "") { String newID = f.getNewID("location_id", "Franchisee_Business_Address"); BAddrsCommand = new SqlCommand("INSERT INTO Franchisee_Business_Address VALUES (" + newID + ", '" + bAddr["bAddr"].ToString() + "', '" + bAddr["bPostal"].ToString() + "', " + bAddr["bProvince"].ToString() + ", " + bAddr["bCity"].ToString() + ", " + bAddr["bCountry"].ToString() + ", " + Properties.Settings.Default.FranchiseeID + ")", con); } else { BAddrsCommand = new SqlCommand("UPDATE Franchisee_Business_Address " + "SET address = '" + bAddr["bAddr"].ToString() + "', postal_code = '" + bAddr["bPostal"].ToString() + "', province_id = " + bAddr["bProvince"].ToString() + ", city_id = " + bAddr["bCity"].ToString() + ", country_id = " + bAddr["bCountry"].ToString() + " WHERE location_id = " + bAddr["locID"].ToString(), con); } con.Open(); BAddrsCommand.ExecuteNonQuery(); con.Close(); }
public static void Set(DataRow usr) { MFranchise f = new MFranchise(); String connString = Properties.Settings.Default.FAFOS; SqlConnection con = new SqlConnection(connString); SqlCommand UsersCommand; int n = usr.ItemArray.Length; for (int i = 0; i < n; i++) { if (usr[i].ToString() == "") { usr[i] = "NULL"; } } if (usr["usrIDCol"].ToString() == "NULL") // Create new User { string newID = f.getNewID("user_id", "[User]"); // assign user id List <Bitmap> piclist = LoadImages(); string newPicID = piclist.Count.ToString(); piclist.Add(Properties.Resources.DefaultProPic); SaveImages(piclist); List <Bitmap> test = LoadImages(); UsersCommand = new SqlCommand("INSERT INTO [User] VALUES (" + newID + ", '" + usr["fName"].ToString() + "', '" + usr["lName"].ToString() + "', '" + usr["mName"].ToString() + "', '" + usr["usrName"].ToString() + "', '" + usr["passSetCol"].ToString() + "', " + "'<empty>','<empty>','<empty>','<empty>','<empty>','<empty>','<empty>','<empty>', '" + usr["hqCol"].ToString() + "', '" + usr["adminCol"].ToString() + "', " + usr["PerOwnCol"].ToString() + ",1,1,1, " + Properties.Settings.Default.FranchiseeID + ", " + newPicID + ")", con); } else { UsersCommand = new SqlCommand("UPDATE [User] SET first_nm = '" + usr["fName"].ToString() + "', last_nm = '" + usr["lName"].ToString() + "', middle_nm = '" + usr["mName"].ToString() + "', username = '******', password = '******', hq_user = '******', admin_user = '******', percentage_ownership = " + usr["PerOwnCol"].ToString() + " WHERE user_id = " + usr["usrIDCol"].ToString(), con); } con.Open(); UsersCommand.ExecuteNonQuery(); con.Close(); }
public static void SetBAddr(DataRow bAddr) { String connString = Properties.Settings.Default.FAFOS; SqlConnection con = new SqlConnection(connString); SqlCommand BAddrsCommand; MFranchise f = new MFranchise(); if (bAddr["locID"].ToString() == "") { String newID = f.getNewID("location_id", "Franchisee_Business_Address"); BAddrsCommand = new SqlCommand("INSERT INTO Franchisee_Business_Address VALUES (" + newID + ", '" + bAddr["bAddr"].ToString() + "', '" + bAddr["bPostal"].ToString() + "', " + bAddr["bProvince"].ToString() + ", " + bAddr["bCity"].ToString() + ", " + bAddr["bCountry"].ToString() + ", " + Properties.Settings.Default.FranchiseeID + ")", con); } else { BAddrsCommand = new SqlCommand("UPDATE Franchisee_Business_Address " + "SET address = '" + bAddr["bAddr"].ToString() + "', postal_code = '" + bAddr["bPostal"].ToString() + "', province_id = " + bAddr["bProvince"].ToString() + ", city_id = " + bAddr["bCity"].ToString() + ", country_id = " + bAddr["bCountry"].ToString() + " WHERE location_id = " + bAddr["locID"].ToString(), con); } con.Open(); BAddrsCommand.ExecuteNonQuery(); con.Close(); }
public static void Set(DataRow usr) { MFranchise f = new MFranchise(); String connString = Properties.Settings.Default.FAFOS; SqlConnection con = new SqlConnection(connString); SqlCommand UsersCommand; int n = usr.ItemArray.Length; for (int i = 0; i < n; i++) if (usr[i].ToString() == "") usr[i] = "NULL"; if (usr["usrIDCol"].ToString() == "NULL") // Create new User { string newID = f.getNewID("user_id", "[User]");// assign user id List<Bitmap> piclist = LoadImages(); string newPicID = piclist.Count.ToString(); piclist.Add(Properties.Resources.DefaultProPic); SaveImages(piclist); List<Bitmap> test = LoadImages(); UsersCommand = new SqlCommand("INSERT INTO [User] VALUES (" + newID + ", '" + usr["fName"].ToString() + "', '" + usr["lName"].ToString() + "', '" + usr["mName"].ToString() + "', '" + usr["usrName"].ToString() + "', '" + usr["passSetCol"].ToString() + "', " + "'<empty>','<empty>','<empty>','<empty>','<empty>','<empty>','<empty>','<empty>', '" + usr["hqCol"].ToString() + "', '" + usr["adminCol"].ToString() + "', " + usr["PerOwnCol"].ToString() + ",1,1,1, " + Properties.Settings.Default.FranchiseeID + ", " + newPicID + ")", con); } else { UsersCommand = new SqlCommand("UPDATE [User] SET first_nm = '" + usr["fName"].ToString() + "', last_nm = '" + usr["lName"].ToString() + "', middle_nm = '" + usr["mName"].ToString() + "', username = '******', password = '******', hq_user = '******', admin_user = '******', percentage_ownership = " + usr["PerOwnCol"].ToString() + " WHERE user_id = " + usr["usrIDCol"].ToString(), con); } con.Open(); UsersCommand.ExecuteNonQuery(); con.Close(); }