public Int32 Save(AccessGroupRightsDetails Details)
{
try
{
string SQL = "CALL procSaveSysAccessGroupRights(@GroupID, @TranTypeID, @AllowRead, @AllowWrite, @CreatedOn, @LastModified);";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("GroupID", Details.GroupID);
cmd.Parameters.AddWithValue("TranTypeID", Details.TranTypeID);
cmd.Parameters.AddWithValue("AllowRead", Details.Read);
cmd.Parameters.AddWithValue("AllowWrite", Details.Write);
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);
return(base.ExecuteNonQuery(cmd));
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
private void Update(AccessGroupRightsDetails Details)
{
try
{
string SQL = string.Empty;
SQL = "UPDATE sysAccessGroupRights SET " +
"AllowRead = @Read, "+
"AllowWrite = @Write " +
"WHERE 1=1 " +
"AND GroupID = @GroupID " +
"AND TranTypeID = @TranTypeID";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmRead = new MySqlParameter("@Read", MySqlDbType.String);
if (Details.Read)
{
prmRead.Value = "1";
}
else
{
prmRead.Value = "0";
}
cmd.Parameters.Add(prmRead);
MySqlParameter prmWrite = new MySqlParameter("@Write", MySqlDbType.String);
if (Details.Write)
{
prmWrite.Value = "1";
}
else
{
prmWrite.Value = "0";
}
cmd.Parameters.Add(prmWrite);
MySqlParameter prmGroupID = new MySqlParameter("@GroupID", MySqlDbType.Int16);
prmGroupID.Value = Details.GroupID;
cmd.Parameters.Add(prmGroupID);
MySqlParameter prmTranTypeID = new MySqlParameter("@TranTypeID", MySqlDbType.Int16);
prmTranTypeID.Value = Details.TranTypeID;
cmd.Parameters.Add(prmTranTypeID);
base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public void Insert(AccessGroupRightsDetails Details)
{
try
{
string SQL = string.Empty;
SQL = "INSERT INTO sysAccessGroupRights " +
"(GroupID, TranTypeID, AllowRead, AllowWrite) " +
"VALUES (@GroupID, @TranTypeID, @Read, @Write)";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmGroupID = new MySqlParameter("@GroupID", MySqlDbType.Int16);
prmGroupID.Value = Details.GroupID;
cmd.Parameters.Add(prmGroupID);
MySqlParameter prmTranTypeID = new MySqlParameter("@TranTypeID", MySqlDbType.Int16);
prmTranTypeID.Value = Details.TranTypeID;
cmd.Parameters.Add(prmTranTypeID);
MySqlParameter prmRead = new MySqlParameter("@Read", MySqlDbType.String);
if (Details.Read)
{
prmRead.Value = "1";
}
else
{
prmRead.Value = "0";
}
cmd.Parameters.Add(prmRead);
MySqlParameter prmWrite = new MySqlParameter("@Write", MySqlDbType.String);
if (Details.Write)
{
prmWrite.Value = "1";
}
else
{
prmWrite.Value = "0";
}
cmd.Parameters.Add(prmWrite);
base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public void Modify(AccessGroupRightsDetails Details)
{
try
{
string SQL = string.Empty;
if (IsExisting(Details.GroupID, Details.TranTypeID))
{
Update(Details);
}
else
{
Insert(Details);
}
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public AccessGroupRightsDetails Details(int GroupID, int TranTypeID)
{
try
{
AllowedRights rights = new AllowedRights();
rights = GetReadWrite(GroupID, TranTypeID);
AccessGroupRightsDetails Details = new AccessGroupRightsDetails();
Details.GroupID = GroupID;
Details.TranTypeID = TranTypeID;
Details.Read = rights.Read;
Details.Write = rights.Write;
return(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public AccessGroupRightsDetails Details(int GroupID, int TranTypeID)
{
try
{
AllowedRights rights = new AllowedRights();
rights = GetReadWrite(GroupID,TranTypeID);
AccessGroupRightsDetails Details = new AccessGroupRightsDetails();
Details.GroupID = GroupID;
Details.TranTypeID = TranTypeID;
Details.Read = rights.Read;
Details.Write = rights.Write;
return Details;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int32 Save(AccessGroupRightsDetails Details)
{
try
{
string SQL = "CALL procSaveSysAccessGroupRights(@GroupID, @TranTypeID, @AllowRead, @AllowWrite, @CreatedOn, @LastModified);";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("GroupID", Details.GroupID);
cmd.Parameters.AddWithValue("TranTypeID", Details.TranTypeID);
cmd.Parameters.AddWithValue("AllowRead", Details.Read);
cmd.Parameters.AddWithValue("AllowWrite", Details.Write);
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);
return base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
private void Update(AccessGroupRightsDetails Details)
{
try
{
string SQL = string.Empty;
SQL = "UPDATE sysAccessGroupRights SET " +
"AllowRead = @Read, " +
"AllowWrite = @Write " +
"WHERE 1=1 " +
"AND GroupID = @GroupID " +
"AND TranTypeID = @TranTypeID";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmRead = new MySqlParameter("@Read",MySqlDbType.String);
if (Details.Read)
prmRead.Value = "1";
else
prmRead.Value = "0";
cmd.Parameters.Add(prmRead);
MySqlParameter prmWrite = new MySqlParameter("@Write",MySqlDbType.String);
if (Details.Write)
prmWrite.Value = "1";
else
prmWrite.Value = "0";
cmd.Parameters.Add(prmWrite);
MySqlParameter prmGroupID = new MySqlParameter("@GroupID",MySqlDbType.Int16);
prmGroupID.Value = Details.GroupID;
cmd.Parameters.Add(prmGroupID);
MySqlParameter prmTranTypeID = new MySqlParameter("@TranTypeID",MySqlDbType.Int16);
prmTranTypeID.Value = Details.TranTypeID;
cmd.Parameters.Add(prmTranTypeID);
base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public void Insert(AccessGroupRightsDetails Details)
{
try
{
string SQL = string.Empty;
SQL = "INSERT INTO sysAccessGroupRights " +
"(GroupID, TranTypeID, AllowRead, AllowWrite) " +
"VALUES (@GroupID, @TranTypeID, @Read, @Write)";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmGroupID = new MySqlParameter("@GroupID",MySqlDbType.Int16);
prmGroupID.Value = Details.GroupID;
cmd.Parameters.Add(prmGroupID);
MySqlParameter prmTranTypeID = new MySqlParameter("@TranTypeID",MySqlDbType.Int16);
prmTranTypeID.Value = Details.TranTypeID;
cmd.Parameters.Add(prmTranTypeID);
MySqlParameter prmRead = new MySqlParameter("@Read",MySqlDbType.String);
if (Details.Read)
prmRead.Value = "1";
else
prmRead.Value = "0";
cmd.Parameters.Add(prmRead);
MySqlParameter prmWrite = new MySqlParameter("@Write",MySqlDbType.String);
if (Details.Write)
prmWrite.Value = "1";
else
prmWrite.Value = "0";
cmd.Parameters.Add(prmWrite);
base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public void Modify(AccessGroupRightsDetails Details)
{
try
{
string SQL = string.Empty;
if (IsExisting(Details.GroupID,Details.TranTypeID))
{
Update(Details);
}
else
{
Insert(Details);
}
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
private int SaveRecord()
{
int id = int.Parse(lblGroupID.Text);
AccessGroupRights clsAccessGroupRights = new AccessGroupRights();
AccessGroupRightsDetails clsDetails;
foreach (DataListItem itemAccessCategory in lstAccessCategory.Items)
{
DataList lstItem = (DataList)itemAccessCategory.FindControl("lstItem");
foreach (DataListItem item in lstItem.Items)
{
HtmlInputCheckBox chkList = (HtmlInputCheckBox)item.FindControl("chkList");
HtmlInputCheckBox chkRead = (HtmlInputCheckBox)item.FindControl("chkRead");
HtmlInputCheckBox chkWrite = (HtmlInputCheckBox)item.FindControl("chkWrite");
clsDetails = new AccessGroupRightsDetails();
clsDetails.GroupID = id;
clsDetails.TranTypeID = int.Parse(chkList.Value);
clsDetails.Read = chkRead.Checked;
clsDetails.Write = chkWrite.Checked;
clsAccessGroupRights.Modify(clsDetails);
}
}
clsAccessGroupRights.CommitAndDispose();
return id;
}
