public DataSet dal_UserManagementdetail(bel_UserManagement obj_bel_User) { DataSet ds = new DataSet(); try { SqlCommand sqlcmd = new SqlCommand("spu_UserManagement"); sqlcmd.CommandTimeout = 0; sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.Clear(); sqlcmd.Parameters.AddWithValue("@PriviledgeID", obj_bel_User._PriviledgeID); sqlcmd.Parameters.AddWithValue("@BranchID", Convert.ToInt32(HttpContext.Current.Session["BranchID"])); sqlcmd.Parameters.AddWithValue("@UserGroupID", obj_bel_User._UserGroupID); sqlcmd.Parameters.AddWithValue("@UserID", obj_bel_User._UserID); sqlcmd.Parameters.AddWithValue("@ModulesGroupID", obj_bel_User._ModulesGroupID); sqlcmd.Parameters.AddWithValue("@ModulesID", obj_bel_User._ModulesID); sqlcmd.Parameters.AddWithValue("@SaveRights", obj_bel_User._SaveRights); sqlcmd.Parameters.AddWithValue("@EditRights", obj_bel_User._EditRights); sqlcmd.Parameters.AddWithValue("@DeleteRights", obj_bel_User._DeleteRights); sqlcmd.Parameters.AddWithValue("@ViewRights", obj_bel_User._ViewRights); sqlcmd.Parameters.AddWithValue("@ViewonlyRights", obj_bel_User._ViewOnlyRights); sqlcmd.Parameters.AddWithValue("@ReportRights", obj_bel_User._ReportRights); sqlcmd.Parameters.AddWithValue("@CompanyID", Convert.ToInt32(HttpContext.Current.Session["CompanyID"])); sqlcmd.Parameters.AddWithValue("@iMode", obj_bel_User._iMode); sqlcmd.Parameters.AddWithValue("@CreatedBy", obj_bel_User._CreatedBy); sqlcmd.Parameters.AddWithValue("@CreatedOn", obj_bel_User._CreatedOn); sqlcmd.Parameters.AddWithValue("@ModifiedBy", obj_bel_User._ModifiedBy); sqlcmd.Parameters.AddWithValue("@ModifiedOn", obj_bel_User._ModifiedOn); ds = DataFunctions.GetDataSet(sqlcmd); } catch (Exception ex) { } return ds; }
public int dal_UserManagementInsert(bel_UserManagement obj_bel_User, DataTable dt) { int value; int Result = 0; string connectionString = ConfigurationManager.ConnectionStrings["SQLConn"].ConnectionString; SqlConnection connection = new SqlConnection(connectionString); SqlTransaction trn; connection.Open(); trn = connection.BeginTransaction(); try { SqlCommand sqlcmd2 = new SqlCommand("spu_UserManagement", connection, trn); sqlcmd2.CommandTimeout = 0; sqlcmd2.CommandType = CommandType.StoredProcedure; for (i = 0; i <= dt.Rows.Count - 1; i++) { sqlcmd2.Parameters.Clear(); if (Convert.ToString(dt.Rows[i]["PriviledgeID"]) == "0") { sqlcmd2.Parameters.AddWithValue("@iMode", "Insert"); sqlcmd2.Parameters.AddWithValue("@PriviledgeID", 0); } else { sqlcmd2.Parameters.AddWithValue("@iMode", "Update"); sqlcmd2.Parameters.AddWithValue("@PriviledgeID", dt.Rows[i]["PriviledgeID"]); } sqlcmd2.Parameters.AddWithValue("@ModulesGroupID", Convert.ToInt32(dt.Rows[i]["ModulesGroupID"].ToString())); sqlcmd2.Parameters.AddWithValue("@ModulesID", Convert.ToInt32(dt.Rows[i]["ModulesID"].ToString())); if (Convert.ToString(dt.Rows[i]["SaveRights"]) != string.Empty) { sqlcmd2.Parameters.AddWithValue("@SaveRights", Convert.ToString(dt.Rows[i]["SaveRights"].ToString())); } else { sqlcmd2.Parameters.AddWithValue("@SaveRights", "N"); } if (Convert.ToString(dt.Rows[i]["EditRights"].ToString()) != string.Empty) { sqlcmd2.Parameters.AddWithValue("@EditRights", Convert.ToString(dt.Rows[i]["EditRights"].ToString())); } else { sqlcmd2.Parameters.AddWithValue("@EditRights", "N"); } if (Convert.ToString(dt.Rows[i]["DeleteRights"].ToString()) != string.Empty) { sqlcmd2.Parameters.AddWithValue("@DeleteRights", Convert.ToString(dt.Rows[i]["DeleteRights"].ToString())); } else { sqlcmd2.Parameters.AddWithValue("@DeleteRights", "N"); } if (Convert.ToString(dt.Rows[i]["ViewRights"].ToString()) != string.Empty) { sqlcmd2.Parameters.AddWithValue("@ViewRights", Convert.ToString(dt.Rows[i]["ViewRights"].ToString())); } else { sqlcmd2.Parameters.AddWithValue("@ViewRights", "N"); } if (Convert.ToString(dt.Rows[i]["ViewonlyRights"].ToString()) != string.Empty) { sqlcmd2.Parameters.AddWithValue("@ViewonlyRights", Convert.ToString(dt.Rows[i]["ViewonlyRights"].ToString())); } else { sqlcmd2.Parameters.AddWithValue("@ViewonlyRights", "N"); } if (Convert.ToString(dt.Rows[i]["ReportRights"].ToString()) != string.Empty) { sqlcmd2.Parameters.AddWithValue("@ReportRights", Convert.ToString(dt.Rows[i]["ReportRights"].ToString())); } else { sqlcmd2.Parameters.AddWithValue("@ReportRights", "N"); } sqlcmd2.Parameters.AddWithValue("@UserGroupID", Convert.ToInt32(obj_bel_User._UserGroupID)); sqlcmd2.Parameters.AddWithValue("@UserID", Convert.ToInt32(obj_bel_User._UserID)); sqlcmd2.Parameters.AddWithValue("@BranchID", Convert.ToInt32(HttpContext.Current.Session["BranchID"])); sqlcmd2.Parameters.AddWithValue("@CompanyID", Convert.ToInt32(HttpContext.Current.Session["CompanyID"])); sqlcmd2.Parameters.AddWithValue("@CreatedBy", Convert.ToInt32(HttpContext.Current.Session["UserID"])); sqlcmd2.Parameters.AddWithValue("@CreatedOn", obj_bel_User._CreatedOn); sqlcmd2.Parameters.AddWithValue("@ModifiedBy", Convert.ToInt32(HttpContext.Current.Session["UserID"])); sqlcmd2.Parameters.AddWithValue("@ModifiedOn", obj_bel_User._ModifiedOn); Result = sqlcmd2.ExecuteNonQuery(); } trn.Commit(); //Dsstockin = DataFunctions.GetDataSet(sqlcmd); } catch (SqlException ex) { trn.Rollback(); } connection.Close(); return Result; }