private Int64 SaveRecord()
{
AccessUser clsAccessUser = new AccessUser();
AccessUserDetails clsDetails = new AccessUserDetails();
clsDetails.UserName = txtUserName.Text;
clsDetails.Password = txtPassword.Text;
clsDetails.Name = txtName.Text;
clsDetails.CountryID = Convert.ToInt32(cboCountry.SelectedItem.Value);
clsDetails.Address1 = txtAddress1.Text;
clsDetails.Address2 = txtAddress2.Text;
clsDetails.City = txtCity.Text;
clsDetails.State = txtState.Text;
clsDetails.OfficePhone = txtOfficePhone.Text;
clsDetails.DirectPhone = txtDirectPhone.Text;
clsDetails.HomePhone = txtHomePhone.Text;
clsDetails.FaxPhone = txtFaxNumber.Text;
clsDetails.MobilePhone = txtMobile.Text;
clsDetails.EmailAddress = txtEmail.Text;
clsDetails.GroupID = Convert.ToInt32(cboGroup.SelectedItem.Value);
Int64 id = clsAccessUser.Insert(clsDetails);
clsAccessUser.CommitAndDispose();
return id;
}
public Int32 Save(AccessUserDetails Details)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "CALL procSaveSysAccessUsers(@UID, @UserName, @Password, @DateCreated, @Deleted, @CreatedOn, @LastModified);";
cmd.Parameters.AddWithValue("UID", Details.UID);
cmd.Parameters.AddWithValue("UserName", Details.UserName);
cmd.Parameters.AddWithValue("Password", Details.Password);
cmd.Parameters.AddWithValue("DateCreated", Details.DateCreated);
cmd.Parameters.AddWithValue("Deleted", Details.Deleted);
cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn);
cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified);
cmd.CommandText = SQL;
return(base.ExecuteNonQuery(cmd));
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
private void ManageSecurity()
{
Security.AccessUserDetails clsAccessUserDetails = (Security.AccessUserDetails)Session["AccessUserDetails"];
AccessRights clsAccessRights = new AccessRights();
AccessRightsDetails clsDetails = new AccessRightsDetails();
clsDetails = clsAccessRights.Details(clsAccessUserDetails.UID, (Int16)AccessTypes.Products);
lnkProducts.Visible = clsDetails.Read;
lnkProductAdd.Visible = clsDetails.Write;
clsDetails = clsAccessRights.Details(clsAccessUserDetails.UID, (int)AccessTypes.SynchronizeBranchProducts);
lnkSynchronize.Visible = clsDetails.Read;
clsDetails = clsAccessRights.Details(clsAccessUserDetails.UID, (Int16)AccessTypes.Contacts);
lnkContact.Visible = clsDetails.Read;
lnkRewards.Visible = clsDetails.Read;
clsDetails = clsAccessRights.Details(clsAccessUserDetails.UID, (Int16)AccessTypes.InventoryList);
lnkInventoryList.Visible = clsDetails.Read;
clsDetails = clsAccessRights.Details(clsAccessUserDetails.UID, (Int16)AccessTypes.StockTransactions);
lnkStock.Visible = clsDetails.Read;
lnkUpload.Visible = clsDetails.Read;
clsDetails = clsAccessRights.Details(clsAccessUserDetails.UID, (Int16)AccessTypes.AccessUsers);
lnkAccessUserAdd.Visible = clsDetails.Write;
clsDetails = clsAccessRights.Details(clsAccessUserDetails.UID, (Int16)AccessTypes.ReportFormat);
lnkReceiptFormatEdit.Visible = clsDetails.Write;
clsAccessRights.CommitAndDispose();
}
public AccessUserDetails Details(Int64 UID)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = SQLSelect() + "WHERE a.UID = @UID;";
cmd.Parameters.AddWithValue("UID", UID);
cmd.CommandText = SQL;
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
AccessUserDetails Details = new AccessUserDetails();
foreach (System.Data.DataRow dr in dt.Rows)
{
Details.UID = UID;
Details.UserName = "" + dr["UserName"].ToString();
Details.Password = "" + dr["Password"].ToString();
Details.DateCreated = DateTime.Parse(dr["DateCreated"].ToString());
Details.Deleted = bool.Parse(dr["Deleted"].ToString());
Details.Name = "" + dr["Name"].ToString();
Details.Address1 = "" + dr["Address1"].ToString();
Details.Address2 = "" + dr["Address2"].ToString();
Details.City = "" + dr["City"].ToString();
Details.State = "" + dr["State"].ToString();
Details.CountryID = Int32.Parse(dr["CountryID"].ToString());
Details.CountryName = "" + dr["CountryName"].ToString();
Details.OfficePhone = "" + dr["OfficePhone"].ToString();
Details.DirectPhone = "" + dr["DirectPhone"].ToString();
Details.HomePhone = "" + dr["HomePhone"].ToString();
Details.FaxPhone = "" + dr["FaxPhone"].ToString();
Details.MobilePhone = "" + dr["MobilePhone"].ToString();
Details.EmailAddress = "" + dr["EmailAddress"].ToString();
Details.GroupID = Int32.Parse(dr["GroupID"].ToString());
Details.GroupName = "" + dr["GroupName"].ToString();
Details.PageSize = Int32.Parse(dr["PageSize"].ToString());
Details.CreatedOn = DateTime.Parse(dr["CreatedOn"].ToString());
Details.LastModified = DateTime.Parse(dr["LastModified"].ToString());
}
return(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int32 SaveDetails(AccessUserDetails Details)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "CALL procSaveSysAccessUserDetails(@UID, @Name, @Address1, @Address2, @City, @State, @Zip, @CountryID," +
"@OfficePhone, @DirectPhone, @HomePhone, @FaxPhone, @MobilePhone, " +
"@EmailAddress, @GroupID, @PageSize, @CreatedOn, @LastModified);";
cmd.Parameters.AddWithValue("UID", Details.UID);
cmd.Parameters.AddWithValue("Name", Details.Name);
cmd.Parameters.AddWithValue("Address1", Details.Address1);
cmd.Parameters.AddWithValue("Address2", Details.Address2);
cmd.Parameters.AddWithValue("City", Details.City);
cmd.Parameters.AddWithValue("State", Details.State);
cmd.Parameters.AddWithValue("Zip", Details.Zip);
cmd.Parameters.AddWithValue("CountryID", Details.CountryID);
cmd.Parameters.AddWithValue("OfficePhone", Details.OfficePhone);
cmd.Parameters.AddWithValue("DirectPhone", Details.DirectPhone);
cmd.Parameters.AddWithValue("HomePhone", Details.HomePhone);
cmd.Parameters.AddWithValue("FaxPhone", Details.FaxPhone);
cmd.Parameters.AddWithValue("MobilePhone", Details.MobilePhone);
cmd.Parameters.AddWithValue("EmailAddress", Details.EmailAddress);
cmd.Parameters.AddWithValue("GroupID", Details.GroupID);
cmd.Parameters.AddWithValue("PageSize", Details.PageSize);
cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn);
cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified);
cmd.CommandText = SQL;
return(base.ExecuteNonQuery(cmd));
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int64 Insert(AccessUserDetails Details)
{
try
{
Int64 iID = 0;
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQLUser = "******";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("UserName", Details.UserName);
cmd.CommandText = SQLUser;
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
if (dt.Rows.Count == 0)
{
SQLUser = "******";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("UserName", Details.UserName);
cmd.Parameters.AddWithValue("Password", Details.Password);
Details.DateCreated = DateTime.Now;
cmd.Parameters.AddWithValue("DateCreated", Details.DateCreated.ToString("yyyy-MM-dd HH:mm:ss"));
cmd.Parameters.AddWithValue("CreatedOn", Details.DateCreated.ToString("yyyy-MM-dd HH:mm:ss"));
cmd.Parameters.AddWithValue("LastModified", Details.DateCreated.ToString("yyyy-MM-dd HH:mm:ss"));
cmd.CommandText = SQLUser;
base.ExecuteNonQuery(cmd);
iID = Int64.Parse(base.getLAST_INSERT_ID(this));
}
else
{
iID = Int64.Parse(dt.Rows[0]["UID"].ToString());
SQLUser = "******";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("UID", iID);
cmd.Parameters.AddWithValue("Password", Details.Password);
cmd.CommandText = SQLUser;
base.ExecuteNonQuery(cmd);
}
Details.UID = iID;
SQLUser = "******";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("UID", iID);
cmd.CommandText = SQLUser;
base.MySqlDataAdapterFill(cmd, dt);
if (dt.Rows.Count != 0)
{
SQLUser = "******" +
"Name = @Name, " +
"Address1 = @Address1, " +
"Address2 = @Address2, " +
"City = @City, " +
"State = @State, " +
"CountryID = @CountryID, " +
"OfficePhone = @OfficePhone, " +
"DirectPhone = @DirectPhone, " +
"HomePhone = @HomePhone, " +
"FaxPhone = @FaxPhone, " +
"MobilePhone = @MobilePhone, " +
"EmailAddress = @EmailAddress, " +
"GroupID = @GroupID, " +
"PageSize = @PageSize " +
"WHERE UID = @UID;";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("Name", Details.Name);
cmd.Parameters.AddWithValue("Address1", Details.Address1);
cmd.Parameters.AddWithValue("Address2", Details.Address2);
cmd.Parameters.AddWithValue("City", Details.City);
cmd.Parameters.AddWithValue("State", Details.State);
cmd.Parameters.AddWithValue("CountryID", Details.CountryID);
cmd.Parameters.AddWithValue("OfficePhone", Details.OfficePhone);
cmd.Parameters.AddWithValue("DirectPhone", Details.DirectPhone);
cmd.Parameters.AddWithValue("HomePhone", Details.HomePhone);
cmd.Parameters.AddWithValue("FaxPhone", Details.FaxPhone);
cmd.Parameters.AddWithValue("MobilePhone", Details.MobilePhone);
cmd.Parameters.AddWithValue("EmailAddress", Details.EmailAddress);
cmd.Parameters.AddWithValue("GroupID", Details.GroupID);
if (Details.PageSize == 0) Details.PageSize = 10;
cmd.Parameters.AddWithValue("PageSize", Details.PageSize);
cmd.Parameters.AddWithValue("UID", Details.UID);
cmd.CommandText = SQLUser;
base.ExecuteNonQuery(cmd);
}
else
{
cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
SQLUser = "******" +
"UID," +
"Name," +
"Address1," +
"Address2," +
"City," +
"State," +
"CountryID," +
"OfficePhone," +
"DirectPhone," +
"HomePhone," +
"FaxPhone," +
"MobilePhone," +
"EmailAddress," +
"GroupID, CreatedOn, LastModified) VALUES ( " +
"@UID," +
"@Name," +
"@Address1," +
"@Address2," +
"@City," +
"@State," +
"@CountryID," +
"@OfficePhone," +
"@DirectPhone," +
"@HomePhone," +
"@FaxPhone," +
"@MobilePhone," +
"@EmailAddress," +
"@GroupID, @CreatedOn, @LastModified);";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("UID", iID);
cmd.Parameters.AddWithValue("Name", Details.Name);
cmd.Parameters.AddWithValue("Address1", Details.Address1);
cmd.Parameters.AddWithValue("Address2", Details.Address2);
cmd.Parameters.AddWithValue("City", Details.City);
cmd.Parameters.AddWithValue("State", Details.State);
cmd.Parameters.AddWithValue("CountryID", Details.CountryID);
cmd.Parameters.AddWithValue("OfficePhone", Details.OfficePhone);
cmd.Parameters.AddWithValue("DirectPhone", Details.DirectPhone);
cmd.Parameters.AddWithValue("HomePhone", Details.HomePhone);
cmd.Parameters.AddWithValue("FaxPhone", Details.FaxPhone);
cmd.Parameters.AddWithValue("MobilePhone", Details.MobilePhone);
cmd.Parameters.AddWithValue("EmailAddress", Details.EmailAddress);
cmd.Parameters.AddWithValue("GroupID", Details.GroupID);
cmd.Parameters.AddWithValue("CreatedOn", Details.DateCreated.ToString("yyyy-MM-dd HH:mm:ss"));
cmd.Parameters.AddWithValue("LastModified", Details.DateCreated.ToString("yyyy-MM-dd HH:mm:ss"));
cmd.CommandText = SQLUser;
base.ExecuteNonQuery(cmd);
}
InsertAccessRights(iID, Details.GroupID);
return iID;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public AccessUserDetails Details(Int64 UID)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = SQLSelect() + "WHERE a.UID = @UID;";
cmd.Parameters.AddWithValue("UID", UID);
cmd.CommandText = SQL;
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
AccessUserDetails Details = new AccessUserDetails();
foreach (System.Data.DataRow dr in dt.Rows)
{
Details.UID = UID;
Details.UserName = "" + dr["UserName"].ToString();
Details.Password = "" + dr["Password"].ToString();
Details.DateCreated = DateTime.Parse(dr["DateCreated"].ToString());
Details.Deleted = bool.Parse(dr["Deleted"].ToString());
Details.Name = "" + dr["Name"].ToString();
Details.Address1 = "" + dr["Address1"].ToString();
Details.Address2 = "" + dr["Address2"].ToString();
Details.City = "" + dr["City"].ToString();
Details.State = "" + dr["State"].ToString();
Details.CountryID = Int32.Parse(dr["CountryID"].ToString());
Details.CountryName = "" + dr["CountryName"].ToString();
Details.OfficePhone = "" + dr["OfficePhone"].ToString();
Details.DirectPhone = "" + dr["DirectPhone"].ToString();
Details.HomePhone = "" + dr["HomePhone"].ToString();
Details.FaxPhone = "" + dr["FaxPhone"].ToString();
Details.MobilePhone = "" + dr["MobilePhone"].ToString();
Details.EmailAddress = "" + dr["EmailAddress"].ToString();
Details.GroupID = Int32.Parse(dr["GroupID"].ToString());
Details.GroupName = "" + dr["GroupName"].ToString();
Details.PageSize = Int32.Parse(dr["PageSize"].ToString());
Details.CreatedOn = DateTime.Parse(dr["CreatedOn"].ToString());
Details.LastModified = DateTime.Parse(dr["LastModified"].ToString());
}
return Details;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int32 SaveDetails(AccessUserDetails Details)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "CALL procSaveSysAccessUserDetails(@UID, @Name, @Address1, @Address2, @City, @State, @Zip, @CountryID," +
"@OfficePhone, @DirectPhone, @HomePhone, @FaxPhone, @MobilePhone, " +
"@EmailAddress, @GroupID, @PageSize, @CreatedOn, @LastModified);";
cmd.Parameters.AddWithValue("UID", Details.UID);
cmd.Parameters.AddWithValue("Name", Details.Name);
cmd.Parameters.AddWithValue("Address1", Details.Address1);
cmd.Parameters.AddWithValue("Address2", Details.Address2);
cmd.Parameters.AddWithValue("City", Details.City);
cmd.Parameters.AddWithValue("State", Details.State);
cmd.Parameters.AddWithValue("Zip", Details.Zip);
cmd.Parameters.AddWithValue("CountryID", Details.CountryID);
cmd.Parameters.AddWithValue("OfficePhone", Details.OfficePhone);
cmd.Parameters.AddWithValue("DirectPhone", Details.DirectPhone);
cmd.Parameters.AddWithValue("HomePhone", Details.HomePhone);
cmd.Parameters.AddWithValue("FaxPhone", Details.FaxPhone);
cmd.Parameters.AddWithValue("MobilePhone", Details.MobilePhone);
cmd.Parameters.AddWithValue("EmailAddress", Details.EmailAddress);
cmd.Parameters.AddWithValue("GroupID", Details.GroupID);
cmd.Parameters.AddWithValue("PageSize", Details.PageSize);
cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn);
cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified);
cmd.CommandText = SQL;
return base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int32 Save(AccessUserDetails Details)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "CALL procSaveSysAccessUsers(@UID, @UserName, @Password, @DateCreated, @Deleted, @CreatedOn, @LastModified);";
cmd.Parameters.AddWithValue("UID", Details.UID);
cmd.Parameters.AddWithValue("UserName", Details.UserName);
cmd.Parameters.AddWithValue("Password", Details.Password);
cmd.Parameters.AddWithValue("DateCreated", Details.DateCreated);
cmd.Parameters.AddWithValue("Deleted", Details.Deleted);
cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn);
cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified);
cmd.CommandText = SQL;
return base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public void Update(AccessUserDetails Details)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQLUser = "";
if (!string.IsNullOrEmpty(Details.Password))
{
SQLUser = "******" +
"UserName = @UserName, " +
"Password = @Password " +
"WHERE UID = @UID;";
cmd.Parameters.AddWithValue("Password", Details.Password);
cmd.Parameters.AddWithValue("UserName", Details.UserName);
cmd.Parameters.AddWithValue("UID", Details.UID);
}
else
{
SQLUser = "******" +
"UserName = @UserName " +
"WHERE UID = @UID;";
cmd.Parameters.AddWithValue("UserName", Details.UserName);
cmd.Parameters.AddWithValue("UID", Details.UID);
}
cmd.CommandText = SQLUser;
base.ExecuteNonQuery(cmd);
cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQLDetails = "UPDATE sysAccessUserDetails SET " +
"Name = @Name, " +
"Address1 = @Address1, " +
"Address2 = @Address2, " +
"City = @City, " +
"State = @State, " +
"CountryID = @CountryID, " +
"OfficePhone = @OfficePhone, " +
"DirectPhone = @DirectPhone, " +
"HomePhone = @HomePhone, " +
"FaxPhone = @FaxPhone, " +
"MobilePhone = @MobilePhone, " +
"EmailAddress = @EmailAddress, " +
"GroupID = @GroupID, " +
"PageSize = @PageSize " +
"WHERE UID = @UID;";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("Name", Details.Name);
cmd.Parameters.AddWithValue("Address1", Details.Address1);
cmd.Parameters.AddWithValue("Address2", Details.Address2);
cmd.Parameters.AddWithValue("City", Details.City);
cmd.Parameters.AddWithValue("State", Details.State);
cmd.Parameters.AddWithValue("CountryID", Details.CountryID);
cmd.Parameters.AddWithValue("OfficePhone", Details.OfficePhone);
cmd.Parameters.AddWithValue("DirectPhone", Details.DirectPhone);
cmd.Parameters.AddWithValue("HomePhone", Details.HomePhone);
cmd.Parameters.AddWithValue("FaxPhone", Details.FaxPhone);
cmd.Parameters.AddWithValue("MobilePhone", Details.MobilePhone);
cmd.Parameters.AddWithValue("EmailAddress", Details.EmailAddress);
cmd.Parameters.AddWithValue("GroupID", Details.GroupID);
if (Details.PageSize == 0) Details.PageSize = 10;
cmd.Parameters.AddWithValue("PageSize", Details.PageSize);
cmd.Parameters.AddWithValue("UID", Details.UID);
cmd.CommandText = SQLDetails;
base.ExecuteNonQuery(cmd);
InsertAccessRights(Details.UID, Details.GroupID);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int64 Insert(AccessUserDetails Details)
{
try
{
Int64 iID = 0;
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQLUser = "******";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("UserName", Details.UserName);
cmd.CommandText = SQLUser;
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
if (dt.Rows.Count == 0)
{
SQLUser = "******";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("UserName", Details.UserName);
cmd.Parameters.AddWithValue("Password", Details.Password);
Details.DateCreated = DateTime.Now;
cmd.Parameters.AddWithValue("DateCreated", Details.DateCreated.ToString("yyyy-MM-dd HH:mm:ss"));
cmd.Parameters.AddWithValue("CreatedOn", Details.DateCreated.ToString("yyyy-MM-dd HH:mm:ss"));
cmd.Parameters.AddWithValue("LastModified", Details.DateCreated.ToString("yyyy-MM-dd HH:mm:ss"));
cmd.CommandText = SQLUser;
base.ExecuteNonQuery(cmd);
iID = Int64.Parse(base.getLAST_INSERT_ID(this));
}
else
{
iID = Int64.Parse(dt.Rows[0]["UID"].ToString());
SQLUser = "******";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("UID", iID);
cmd.Parameters.AddWithValue("Password", Details.Password);
cmd.CommandText = SQLUser;
base.ExecuteNonQuery(cmd);
}
Details.UID = iID;
SQLUser = "******";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("UID", iID);
cmd.CommandText = SQLUser;
base.MySqlDataAdapterFill(cmd, dt);
if (dt.Rows.Count != 0)
{
SQLUser = "******" +
"Name = @Name, "+
"Address1 = @Address1, "+
"Address2 = @Address2, "+
"City = @City, "+
"State = @State, "+
"CountryID = @CountryID, "+
"OfficePhone = @OfficePhone, "+
"DirectPhone = @DirectPhone, "+
"HomePhone = @HomePhone, "+
"FaxPhone = @FaxPhone, "+
"MobilePhone = @MobilePhone, "+
"EmailAddress = @EmailAddress, "+
"GroupID = @GroupID, "+
"PageSize = @PageSize "+
"WHERE UID = @UID;";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("Name", Details.Name);
cmd.Parameters.AddWithValue("Address1", Details.Address1);
cmd.Parameters.AddWithValue("Address2", Details.Address2);
cmd.Parameters.AddWithValue("City", Details.City);
cmd.Parameters.AddWithValue("State", Details.State);
cmd.Parameters.AddWithValue("CountryID", Details.CountryID);
cmd.Parameters.AddWithValue("OfficePhone", Details.OfficePhone);
cmd.Parameters.AddWithValue("DirectPhone", Details.DirectPhone);
cmd.Parameters.AddWithValue("HomePhone", Details.HomePhone);
cmd.Parameters.AddWithValue("FaxPhone", Details.FaxPhone);
cmd.Parameters.AddWithValue("MobilePhone", Details.MobilePhone);
cmd.Parameters.AddWithValue("EmailAddress", Details.EmailAddress);
cmd.Parameters.AddWithValue("GroupID", Details.GroupID);
if (Details.PageSize == 0)
{
Details.PageSize = 10;
}
cmd.Parameters.AddWithValue("PageSize", Details.PageSize);
cmd.Parameters.AddWithValue("UID", Details.UID);
cmd.CommandText = SQLUser;
base.ExecuteNonQuery(cmd);
}
else
{
cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
SQLUser = "******" +
"UID," +
"Name," +
"Address1," +
"Address2," +
"City," +
"State," +
"CountryID," +
"OfficePhone," +
"DirectPhone," +
"HomePhone," +
"FaxPhone," +
"MobilePhone," +
"EmailAddress," +
"GroupID, CreatedOn, LastModified) VALUES ( " +
"@UID," +
"@Name," +
"@Address1," +
"@Address2," +
"@City," +
"@State," +
"@CountryID," +
"@OfficePhone," +
"@DirectPhone," +
"@HomePhone," +
"@FaxPhone," +
"@MobilePhone," +
"@EmailAddress," +
"@GroupID, @CreatedOn, @LastModified);";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("UID", iID);
cmd.Parameters.AddWithValue("Name", Details.Name);
cmd.Parameters.AddWithValue("Address1", Details.Address1);
cmd.Parameters.AddWithValue("Address2", Details.Address2);
cmd.Parameters.AddWithValue("City", Details.City);
cmd.Parameters.AddWithValue("State", Details.State);
cmd.Parameters.AddWithValue("CountryID", Details.CountryID);
cmd.Parameters.AddWithValue("OfficePhone", Details.OfficePhone);
cmd.Parameters.AddWithValue("DirectPhone", Details.DirectPhone);
cmd.Parameters.AddWithValue("HomePhone", Details.HomePhone);
cmd.Parameters.AddWithValue("FaxPhone", Details.FaxPhone);
cmd.Parameters.AddWithValue("MobilePhone", Details.MobilePhone);
cmd.Parameters.AddWithValue("EmailAddress", Details.EmailAddress);
cmd.Parameters.AddWithValue("GroupID", Details.GroupID);
cmd.Parameters.AddWithValue("CreatedOn", Details.DateCreated.ToString("yyyy-MM-dd HH:mm:ss"));
cmd.Parameters.AddWithValue("LastModified", Details.DateCreated.ToString("yyyy-MM-dd HH:mm:ss"));
cmd.CommandText = SQLUser;
base.ExecuteNonQuery(cmd);
}
InsertAccessRights(iID, Details.GroupID);
return(iID);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public void Update(AccessUserDetails Details)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQLUser = "";
if (!string.IsNullOrEmpty(Details.Password))
{
SQLUser = "******" +
"UserName = @UserName, " +
"Password = @Password " +
"WHERE UID = @UID;";
cmd.Parameters.AddWithValue("Password", Details.Password);
cmd.Parameters.AddWithValue("UserName", Details.UserName);
cmd.Parameters.AddWithValue("UID", Details.UID);
}
else
{
SQLUser = "******" +
"UserName = @UserName " +
"WHERE UID = @UID;";
cmd.Parameters.AddWithValue("UserName", Details.UserName);
cmd.Parameters.AddWithValue("UID", Details.UID);
}
cmd.CommandText = SQLUser;
base.ExecuteNonQuery(cmd);
cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQLDetails = "UPDATE sysAccessUserDetails SET " +
"Name = @Name, "+
"Address1 = @Address1, "+
"Address2 = @Address2, "+
"City = @City, "+
"State = @State, "+
"CountryID = @CountryID, "+
"OfficePhone = @OfficePhone, "+
"DirectPhone = @DirectPhone, "+
"HomePhone = @HomePhone, "+
"FaxPhone = @FaxPhone, "+
"MobilePhone = @MobilePhone, "+
"EmailAddress = @EmailAddress, "+
"GroupID = @GroupID, "+
"PageSize = @PageSize "+
"WHERE UID = @UID;";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("Name", Details.Name);
cmd.Parameters.AddWithValue("Address1", Details.Address1);
cmd.Parameters.AddWithValue("Address2", Details.Address2);
cmd.Parameters.AddWithValue("City", Details.City);
cmd.Parameters.AddWithValue("State", Details.State);
cmd.Parameters.AddWithValue("CountryID", Details.CountryID);
cmd.Parameters.AddWithValue("OfficePhone", Details.OfficePhone);
cmd.Parameters.AddWithValue("DirectPhone", Details.DirectPhone);
cmd.Parameters.AddWithValue("HomePhone", Details.HomePhone);
cmd.Parameters.AddWithValue("FaxPhone", Details.FaxPhone);
cmd.Parameters.AddWithValue("MobilePhone", Details.MobilePhone);
cmd.Parameters.AddWithValue("EmailAddress", Details.EmailAddress);
cmd.Parameters.AddWithValue("GroupID", Details.GroupID);
if (Details.PageSize == 0)
{
Details.PageSize = 10;
}
cmd.Parameters.AddWithValue("PageSize", Details.PageSize);
cmd.Parameters.AddWithValue("UID", Details.UID);
cmd.CommandText = SQLDetails;
base.ExecuteNonQuery(cmd);
InsertAccessRights(Details.UID, Details.GroupID);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
private void SaveRecord()
{
AccessUser clsAccessUser = new AccessUser();
AccessUserDetails clsDetails = new AccessUserDetails();
clsDetails.UID = Convert.ToInt64(lblUID.Text);
clsDetails.UserName = txtUserName.Text;
clsDetails.Password = txtPassword.Text;
clsDetails.Name = txtName.Text;
clsDetails.CountryID = Convert.ToInt32(cboCountry.SelectedItem.Value);
clsDetails.Address1 = txtAddress1.Text;
clsDetails.Address2 = txtAddress2.Text;
clsDetails.City = txtCity.Text;
clsDetails.State = txtState.Text;
clsDetails.OfficePhone = txtOfficePhone.Text;
clsDetails.DirectPhone = txtDirectPhone.Text;
clsDetails.HomePhone = txtHomePhone.Text;
clsDetails.FaxPhone = txtFaxNumber.Text;
clsDetails.MobilePhone = txtMobile.Text;
clsDetails.EmailAddress = txtEmail.Text;
clsDetails.GroupID = Convert.ToInt32(cboGroup.SelectedItem.Value);
clsDetails.PageSize = Convert.ToInt32(txtPageSize.Text);
clsAccessUser.Update(clsDetails);
clsAccessUser.CommitAndDispose();
AssignUserSession(clsDetails);
}
private void AssignUserSession(AccessUserDetails clsDetails)
{
Session["AccessUserDetails"] = clsDetails;
// Session.RemoveAll();
Session.Add("PageSize",clsDetails.PageSize);
Session.Add("UID", clsDetails.UID);
Session.Add("UserName", clsDetails.UserName);
Session.Add("Password", clsDetails.Password);
Session.Add("Name",clsDetails.Name);
Session.Add("CountryID", clsDetails.CountryID);
Session.Add("Addres1", clsDetails.Address1);
Session.Add("Addres2", clsDetails.Address2);
Session.Add("City", clsDetails.City);
Session.Add("State", clsDetails.State);
Session.Add("OfficePhone", clsDetails.OfficePhone);
Session.Add("DirectPhone", clsDetails.DirectPhone);
Session.Add("HomePhone", clsDetails.HomePhone);
Session.Add("FaxPhone", clsDetails.FaxPhone);
Session.Add("MobilePhone", clsDetails.MobilePhone);
Session.Add("EmailAddress", clsDetails.EmailAddress);
}