private SqlCommand DeclareSqlCmdParameter(SqlCommand SqlCmd, DEUserPermission userPermission)
{
SqlCmd.Parameters.AddWithValue("@UserId", userPermission.UserId);
SqlCmd.Parameters.AddWithValue("@PermissionId", userPermission.PermissionId);
return(SqlCmd);
}
public int UpdateData(DEUser user, DataTable dt_Permission)
{
int int_Result = 0;
DALUserPermission obj_DALUserPermission = new DALUserPermission();
DEUserPermission userPermission = new DEUserPermission();
userPermission.UserId = user.UserId;
SqlConnection SqlCon = new SqlConnection(SqlConjunction.DataConn);
try
{
if (SqlCon.State != ConnectionState.Open)
{
SqlCon.Open();
}
}
catch (SqlException ex)
{
Console.WriteLine(ex);
}
SqlTransaction tn = SqlCon.BeginTransaction();
{
try
{
this.UpdateData(user, SqlCon, tn);
obj_DALUserPermission.DeleteData(userPermission, SqlCon, tn);
for (int i = 0; i < dt_Permission.Rows.Count; i++)
{
userPermission.PermissionId = Convert.ToInt32(dt_Permission.Rows[i][0].ToString());
obj_DALUserPermission.InsertData(userPermission, SqlCon, tn);
}
tn.Commit();
int_Result = 1;
}
catch (Exception ex)
{
tn.Rollback();
int_Result = 0;
throw (ex);
}
finally
{
obj_DALUserPermission = null;
SqlCon.Close();
tn.Dispose();
}
return(int_Result);
}
}
public int DeleteData(DEUserPermission userPermission, SqlConnection SqlCon, SqlTransaction tn)
{
int int_Result;
SqlCommand sqlCmd = new SqlCommand(" ", SqlCon, tn);
sqlCmd.CommandText = "Delete tbl_UserPermission where UserId = @UserId";
DeclareSqlCmdParameter(sqlCmd, userPermission);
int_Result = SqlConjunction.GetSQLTransVoid(sqlCmd);
sqlCmd = null;
return(int_Result);
}
public int InsertData(DEUserPermission userPermission, SqlConnection SqlCon, SqlTransaction tn)
{
int int_Result;
SqlCommand sqlCmd = new SqlCommand(" ", SqlCon, tn);
sqlCmd.CommandText = "INSERT tbl_UserPermission VALUES(@UserId,@PermissionId)";
DeclareSqlCmdParameter(sqlCmd, userPermission);
int_Result = SqlConjunction.GetSQLTransVoid(sqlCmd);
sqlCmd = null;
return(int_Result);
}