public DateTime GetCurrentDayProcessDate()
{
DBEgine objDbAccess = new DBEgine();
DateTime currentDate = DateTime.Now;
try
{
objDbAccess.DBOpen();
SqlDataReader dr = objDbAccess.ExecuteReader("[admin].GetCurrentDayProcess ", null);
while (dr.Read())
{
currentDate = DateTime.Parse(dr["DayProcessDate"].ToString());
}
return currentDate;
}
catch (Exception ex)
{
throw ex;
}
finally
{
objDbAccess.DBClose();
}
}
public List<SubItemLookUp> GetAllSubItemsForLookUp()
{
DBEgine objDbAccess = new DBEgine();
var list = new List<SubItemLookUp>();
try
{
objDbAccess.DBOpen();
SqlDataReader dr = objDbAccess.ExecuteReader("Inventory.GetAllSubItems", null);
while (dr.Read())
{
var subItem = new SubItemLookUp();
subItem.SubItemID = int.Parse(dr["SubItemID"].ToString());
subItem.SubItemSerial = dr["SubItemSerial"].ToString();
subItem.SubItemDescription = dr["SubItemDescription"].ToString();
subItem.SubItemUnitPrice = Convert.ToDecimal(dr["SubItemUnitPrice"].ToString());
list.Add(subItem);
}
return list;
}
catch (Exception ex)
{
throw ex;
}
finally
{
objDbAccess.DBClose();
}
}
public void DeactivateUsersessionByInterval(int interval)
{
DBEgine dbEngine = new DBEgine();
try
{
dbEngine.DBOpen();
SqlParameter[] parms = new SqlParameter[1];
SqlParameter p1 = new SqlParameter();
p1.ParameterName = "intervalSecond";
p1.SqlDbType = SqlDbType.Int;
p1.Value = interval;
parms[0] = p1;
dbEngine.ExecNonQueryStoredProc("UM_DeactivateUsersessionByInterval", parms);
}
catch
{
throw;
}
finally
{
dbEngine.DBClose();
}
}
public DataSet Report_GetUserRoles(int branchId, string userIdList)
{
DBEgine dbEngin = new DBEgine ();
try
{
string BranchId = branchId.ToString();
SqlParameter branchIdParam = new SqlParameter("@BranchId", SqlDbType.VarChar,10);
branchIdParam.Value = BranchId;
SqlParameter userListParam = new SqlParameter("@userId", SqlDbType.VarChar, 800);
userListParam.Value = userIdList;
SqlParameter[] paramList = { branchIdParam, userListParam };
dbEngin.DBOpen();
return dbEngin.ExecuteDataSet("UM_Report_GerUserRoles", paramList);
}
catch
{
throw;
}
finally
{
dbEngin.DBClose();
}
}
public List<InvoiceHeaderBO> GetAllInvoicesForCurrentDate()
{
DBEgine objDbAccess = new DBEgine();
var list = new List<InvoiceHeaderBO>();
try
{
objDbAccess.DBOpen();
SqlDataReader dr = objDbAccess.ExecuteReader("Sales.GetCurrentDayInvoices", null);
while (dr.Read())
{
var invoice = new InvoiceHeaderBO();
invoice.InvoiceID = int.Parse(dr["InvoiceID"].ToString());
invoice.InvoiceNumber = dr["InvoiceNumber"].ToString();
list.Add(invoice);
}
return list;
}
catch (Exception ex)
{
throw ex;
}
finally
{
objDbAccess.DBClose();
}
}
public List<UserBranchesDetailsBO> LoadAllUserBranchesByUserID(int userId)
{
List<UserBranchesDetailsBO> userBranchesList=new List<UserBranchesDetailsBO>();
UserBranchesDetailsBO userBranch = new UserBranchesDetailsBO();
DBEgine dbEgine = new DBEgine();
try{
SqlParameter[] parms = new SqlParameter[1];
SqlParameter p1 = new SqlParameter();
p1.ParameterName = "UserID";
p1.SqlDbType = SqlDbType.Int;
p1.Direction = ParameterDirection.Input;
p1.Value = userId;
parms[0] = p1;
dbEgine.DBOpen();
SqlDataReader drUserBranches = dbEgine.ExecuteReader("UserManagement.UM_LoadUserBranchesByUserID", parms);
if (drUserBranches != null && drUserBranches.HasRows )
{
while(drUserBranches.Read()){
userBranch=FillUserBranches(drUserBranches);
userBranchesList.Add(userBranch);
}
}
return userBranchesList;
}
catch{
throw;
}
finally{
dbEgine.DBClose();
}
}
public List<MeasuringUnitLookUp> GetAllMeasuringUnitsForLookUp()
{
DBEgine objDbAccess = new DBEgine();
var list = new List<MeasuringUnitLookUp>();
try
{
objDbAccess.DBOpen();
SqlDataReader dr = objDbAccess.ExecuteReader("Inventory.GetMeasuringUnits", null);
while (dr.Read())
{
var item = new MeasuringUnitLookUp();
item.UnitID = Convert.ToInt32(dr["UnitID"].ToString());
item.UnitDescription = dr["UnitDescription"].ToString();
list.Add(item);
}
return list;
}
catch (Exception ex)
{
throw ex;
}
finally
{
objDbAccess.DBClose();
}
}
public bool DeleteSubItemByID(int id)
{
DBEgine objDbAccess = new DBEgine();
bool result = false;
try
{
SqlParameter[] parms = new SqlParameter[1];
SqlParameter parmItemID = new SqlParameter();
parmItemID.Value = id;
parmItemID.SqlDbType = SqlDbType.Int;
parmItemID.Direction = ParameterDirection.Input;
parmItemID.ParameterName = "@SubItemID";
parms[0] = parmItemID;
objDbAccess.DBOpen();
int count = objDbAccess.ExecNonQueryStoredProc("Inventory.DeleteSubItem", parms);
if (count > 0)
{
result = true;
}
return result;
}
catch (Exception ex)
{
throw ex;
}
finally
{
objDbAccess.DBClose();
}
}
public bool CompleteDayProcess(int user)
{
DBEgine objDbAccess = new DBEgine();
bool result = false;
try
{
objDbAccess.DBOpen();
SqlParameter[] parms = new SqlParameter[1];
SqlParameter parmUserID = new SqlParameter();
parmUserID.Value = user;
parmUserID.SqlDbType = SqlDbType.Int;
parmUserID.Direction = ParameterDirection.Input;
parmUserID.ParameterName = "@User";
parms[0] = parmUserID;
objDbAccess.ExecNonQueryStoredProc("[admin].CompleteDayProcess ", parms);
result = true;
return result;
}
catch (Exception ex)
{
throw ex;
}
finally
{
objDbAccess.DBClose();
}
}
public UserPaswordHistoryBO GetCurrentPaswordDetails(DBEgine dbEngine,int userID)
{
UserPaswordHistoryBO hs = null;
try
{
SqlParameter[] parms = new SqlParameter[1];
SqlParameter p1 = new SqlParameter();
p1.ParameterName = "@UserID";
p1.SqlDbType = SqlDbType.Int;
p1.Direction = ParameterDirection.Input;
p1.Value = userID;
parms[0] = p1;
DataTable dtHistry = dbEngine.ExecuteDataTable("UserManagement.UM_GetCurrentPasswordDetails", parms);
if (dtHistry.Rows.Count > 0)
{
foreach (DataRow r in dtHistry.Rows)
{
hs = new UserPaswordHistoryBO();
if (r.Table.Columns.Contains("UserPaswordHistoryID"))
if (r["UserPaswordHistoryID"] != DBNull.Value)
hs.UserPaswordHistoryID = (int)r["UserPaswordHistoryID"];
if (r.Table.Columns.Contains("UserID"))
if (r["UserID"] != DBNull.Value)
hs.UserID = (int)r["UserID"];
if (r.Table.Columns.Contains("Password"))
if (r["Password"] != DBNull.Value)
hs.Password = r["Password"].ToString();
if (r.Table.Columns.Contains("CreatedBy"))
if (r["CreatedBy"] != DBNull.Value)
hs.CreatedBy = (int)r["CreatedBy"];
if (r.Table.Columns.Contains("CreatedDate"))
if (r["CreatedDate"] != DBNull.Value)
hs.CreatedDate = DateTime.Parse(r["CreatedDate"].ToString());
if (r.Table.Columns.Contains("DayProcessID"))
if (r["DayProcessID"] != DBNull.Value)
hs.DayProcessID = r["DayProcessID"].ToString();
if (r.Table.Columns.Contains("IsCurrent"))
if (r["IsCurrent"] != DBNull.Value)
hs.IsCurrent = (bool)r["IsCurrent"];
}
}
return hs;
}
catch
{
throw;
}
}
public List<UserLevelsBO> LoadActiveUserLevels()
{
DBEgine dbEgine = new DBEgine();
List<UserLevelsBO> userLevelsList = new List<UserLevelsBO>();
try
{
dbEgine.DBOpen();
SqlDataReader drUserLevels = dbEgine.ExecuteReader("UserManagement.UM_LoadActiveUserLevels", null);
if (drUserLevels != null && drUserLevels.HasRows)
{
while (drUserLevels.Read())
{
UserLevelsBO userLevelObj = new UserLevelsBO();
userLevelObj = FillUserLevel(drUserLevels);
userLevelsList.Add(userLevelObj);
}
}
return userLevelsList;
}
catch
{
throw;
}
finally
{
dbEgine.DBClose();
}
}
public UserLevelsBO GetNextUserLevelByCurrentUserLevelID(int currentUserLevelID)
{
DBEgine dbEgine = new DBEgine();
try
{
UserLevelsBO userLevelObj = new UserLevelsBO();
SqlParameter[] parms = new SqlParameter[1];
dbEgine.DBOpen();
SqlParameter userLevelIdParm = new SqlParameter();
userLevelIdParm.ParameterName = "@UserLevelId";
userLevelIdParm.SqlDbType = SqlDbType.Int;
userLevelIdParm.Direction = ParameterDirection.Input;
userLevelIdParm.Value = currentUserLevelID;
parms[0] = userLevelIdParm;
SqlDataReader drUserLevels = dbEgine.ExecuteReader("UserManagement.UM_GetNextUserLevelByCurrentUserLevel", parms);
if (drUserLevels != null && drUserLevels.HasRows && drUserLevels.Read())
{
userLevelObj = FillUserLevel(drUserLevels);
}
return userLevelObj;
}
catch
{
throw;
}
finally
{
dbEgine.DBClose();
}
}
public int AddUserBranchDetails(DBEgine dbEgine,int userId,UserBranchesDetailsBO obj)
{
try {
SqlParameter[] paramArray = new SqlParameter[3];
SqlParameter branchIDParam = new SqlParameter();
branchIDParam.ParameterName = "@BranchID";
branchIDParam.SqlDbType = SqlDbType.Int;
branchIDParam.Direction = ParameterDirection.Input;
branchIDParam.Value = obj.BranchID;
paramArray[0] = branchIDParam;
SqlParameter userIDParam = new SqlParameter();
userIDParam.ParameterName = "@UserID";
userIDParam.SqlDbType = SqlDbType.Int;
userIDParam.Direction = ParameterDirection.Input;
userIDParam.Value = obj.UserID;
paramArray[1] = userIDParam;
SqlParameter isPrimaryParam = new SqlParameter();
isPrimaryParam.ParameterName = "@IsPrimary";
isPrimaryParam.SqlDbType = SqlDbType.Bit;
isPrimaryParam.Direction = ParameterDirection.Input;
isPrimaryParam.Value = obj.IsPrimary;
paramArray[2] = isPrimaryParam;
dbEgine.ExecNonQueryStoredProc("UserManagement.UM_AddUserBranchesDetails", paramArray);
return obj.BranchID;
}
catch
{
throw;
}
}
public List<ScreenFunctionsBO> LoadGrantedScreenFunctionsbyScreenIDandUserName(int screenId, string userName)
{
DBEgine dbEgine = new DBEgine();
List<ScreenBO> screenList = new List<ScreenBO>();
try
{
dbEgine.DBOpen();
SqlParameter[] parms = new SqlParameter[2];
SqlParameter p1 = new SqlParameter();
p1.ParameterName = "UserName";
p1.SqlDbType = SqlDbType.NVarChar;
p1.Size = 256;
p1.Direction = ParameterDirection.Input;
p1.Value = userName;
parms[0] = p1;
SqlParameter p2 = new SqlParameter();
p2.ParameterName = "ScreenId";
p2.SqlDbType = SqlDbType.Int;
p2.Direction = ParameterDirection.Input;
p2.Value = screenId;
parms[1] = p2;
SqlDataReader drScreenFunctionList = dbEgine.ExecuteReader("UM_LoadGrantedScreenFunctionsbyScreenIDandUserName", parms);
List<ScreenFunctionsBO> screenFunctionsList = new List<ScreenFunctionsBO>();
while (drScreenFunctionList.Read())
{
ScreenFunctionsBO screenFunction = new ScreenFunctionsBO();
screenFunction.ScreenFunctionCode = drScreenFunctionList.GetValue(drScreenFunctionList.GetOrdinal("ScreenFunctionCode")).ToString();
screenFunction.FunctionName = drScreenFunctionList.GetValue(drScreenFunctionList.GetOrdinal("FunctionName")).ToString();
screenFunction.IsActive = drScreenFunctionList.GetBoolean(drScreenFunctionList.GetOrdinal("IsActive"));
screenFunction.IsGranted = drScreenFunctionList.GetBoolean(drScreenFunctionList.GetOrdinal("IsGranted"));
screenFunctionsList.Add(screenFunction);
}
dbEgine.DBClose();
return screenFunctionsList;
}
catch
{
throw;
}
finally
{
dbEgine.DBClose();
}
}
public List<ScreenBO> LoadGrantedScreensByRoleID(int roleId)
{
DBEgine dbEgine = new DBEgine();
List<ScreenBO> screenList = new List<ScreenBO>();
try
{
dbEgine.DBOpen();
SqlParameter[] parms = new SqlParameter[1];
SqlParameter p1 = new SqlParameter();
p1.ParameterName = "@RoleId";
p1.SqlDbType = SqlDbType.Int;
p1.Direction = ParameterDirection.Input;
p1.Value = roleId;
parms[0] = p1;
SqlDataReader drScreenList = dbEgine.ExecuteReader("UserManagement.UM_LoadGrantedScreensByRoleID", parms);
while (drScreenList.Read())
{
ScreenBO objscreen = new ScreenBO();
objscreen.ScreenId = drScreenList.GetInt32(drScreenList.GetOrdinal("ScreenId"));
objscreen.ScreenName = drScreenList.GetValue(drScreenList.GetOrdinal("Screen")).ToString();
objscreen.Url = drScreenList.GetValue(drScreenList.GetOrdinal("URL")).ToString();
objscreen.ScreenParentId = drScreenList.GetInt32(drScreenList.GetOrdinal("ScreenParentId"));
objscreen.IsMenu = drScreenList.GetBoolean(drScreenList.GetOrdinal("IsMenu"));
objscreen.IsEnable = drScreenList.GetBoolean(drScreenList.GetOrdinal("IsEnable"));
objscreen.ScreenOrderId = drScreenList.GetInt32(drScreenList.GetOrdinal("ScreenOrderId"));
List<ScreenFunctionsBO> listScreenFuntions = new ScreenFunctionsDAL().LoadScreenFunctions(objscreen.ScreenId, roleId);
objscreen.ScreenFunctions = new List<ScreenFunctionsBO>();
if (listScreenFuntions != null && listScreenFuntions.Count > 0)
{
objscreen.ScreenFunctions = listScreenFuntions;
}
screenList.Add(objscreen);
}
dbEgine.DBClose();
return screenList;
}
catch
{
throw;
}
finally
{
dbEgine.DBClose();
}
}
public bool AddMeasurementUnit(MeasurementUnitBO measurementUnit)
{
DBEgine objDbAccess = new DBEgine();
bool result = false;
try
{
SqlParameter[] parms = new SqlParameter[4];
SqlParameter parmUnitID = new SqlParameter();
parmUnitID.Value = measurementUnit.UnitID;
parmUnitID.SqlDbType = SqlDbType.Int;
parmUnitID.Direction = ParameterDirection.Input;
parmUnitID.ParameterName = "@UnitID";
parms[0] = parmUnitID;
SqlParameter parmUnitDescription = new SqlParameter();
parmUnitDescription.Value = measurementUnit.UnitDescription;
parmUnitDescription.SqlDbType = SqlDbType.VarChar;
parmUnitDescription.Direction = ParameterDirection.Input;
parmUnitDescription.ParameterName = "@UnitDescription";
parms[1] = parmUnitDescription;
SqlParameter parmIsActive = new SqlParameter();
parmIsActive.Value = measurementUnit.IsActive;
parmIsActive.SqlDbType = SqlDbType.Bit;
parmIsActive.Direction = ParameterDirection.Input;
parmIsActive.ParameterName = "@IsActive";
parms[2] = parmIsActive;
SqlParameter parmCreatedUser = new SqlParameter();
parmCreatedUser.Value = measurementUnit.CreatedUser;
parmCreatedUser.SqlDbType = SqlDbType.Int;
parmCreatedUser.Direction = ParameterDirection.Input;
parmCreatedUser.ParameterName = "@CreatedUser";
parms[3] = parmCreatedUser;
objDbAccess.DBOpen();
if (objDbAccess.ExecNonQueryStoredProc("Inventory.SaveMeasurementUnit", parms) > 0)
{
result = true;
}
return result;
}
catch (Exception ex)
{
throw ex;
}
finally
{
objDbAccess.DBClose();
}
}
public static List<RelationshipBO> GetAllRelationship()
{
List<RelationshipBO> listRel = new List<RelationshipBO>();
DBEgine dbEgine = new DBEgine();
try
{
dbEgine.DBOpen();
DataTable dt = dbEgine.ExecuteDataTable("U_GetAllRelationship", null);
if (dt.Rows.Count > 0)
{
foreach (DataRow r in dt.Rows)
{
var relationshipBO = new RelationshipBO();
if (r["RelationShipID"] != DBNull.Value)
relationshipBO.RelationShipID = (int)r["RelationShipID"];
if (r["RelationShipName"] != DBNull.Value)
relationshipBO.RelationShipName = r["RelationShipName"].ToString();
if (r["IsActive"] != DBNull.Value)
relationshipBO.IsActive = (bool)r["IsActive"];
if (r["CreatedBy"] != DBNull.Value)
relationshipBO.CreatedBy = (int)r["CreatedBy"];
if (r["CreatedDate"] != DBNull.Value)
relationshipBO.CreatedDate = (DateTime)r["CreatedDate"];
if (r["ModifiedBy"] != DBNull.Value)
relationshipBO.ModifiedBy = (int)r["ModifiedBy"];
if (r["ModifiedDate"] != DBNull.Value)
relationshipBO.ModifiedDate = (DateTime)r["ModifiedDate"];
listRel.Add(relationshipBO);
}
}
}
catch
{
throw;
}
finally
{
dbEgine.DBClose();
}
return listRel;
}
public List<UserRolesBO> LoadUserRolesByUserName(string UserName, string Password)
{
DBEgine dbEgine = new DBEgine();
List<UserRolesBO> userRoleList = new List<UserRolesBO>();
try
{
dbEgine.DBOpen();
SqlParameter[] parms = new SqlParameter[2];
SqlParameter userNameParm = new SqlParameter();
userNameParm.ParameterName = "@UserName";
userNameParm.SqlDbType = SqlDbType.NVarChar;
userNameParm.Direction = ParameterDirection.Input;
userNameParm.Value = UserName;
parms[0] = userNameParm;
SqlParameter passwordParm = new SqlParameter();
passwordParm.ParameterName = "@password";
passwordParm.SqlDbType = SqlDbType.VarChar;
passwordParm.Direction = ParameterDirection.Input;
passwordParm.Value = Password;
parms[1] = passwordParm;
SqlDataReader drUserRoles = dbEgine.ExecuteReader("UM_LoadUserRolesByUserName", parms);
if (drUserRoles != null && drUserRoles.HasRows)
{
while (drUserRoles.Read())
{
UserRolesBO userRoleObj = new UserRolesBO();
userRoleObj.UserRoleName = drUserRoles.GetValue(drUserRoles.GetOrdinal("UserRoleName")).ToString();
userRoleList.Add(userRoleObj);
}
}
return userRoleList;
}
catch
{
throw;
}
finally
{
dbEgine.DBClose();
}
}
public int SaveUserPaswordHistory(DBEgine dbEngine, UserPaswordHistoryBO upHistry)
{
int ID = -1;
try
{
SqlParameter[] arrSqlParam = GetFDUpLiftmentParameters(upHistry);
dbEngine.ExecNonQueryStoredProc("UserManagement.UM_SaveUserPasswordHistory", arrSqlParam);
}
catch
{
throw;
}
return ID;
}
public List<SubItemDetailBO> GetSubItemDetailBySubItemID(int id)
{
DBEgine objDbAccess = new DBEgine();
var list = new List<SubItemDetailBO>();
try
{
SqlParameter[] parms = new SqlParameter[1];
SqlParameter parmItemID = new SqlParameter();
parmItemID.Value = id;
parmItemID.SqlDbType = SqlDbType.Int;
parmItemID.Direction = ParameterDirection.Input;
parmItemID.ParameterName = "@SubItemID";
parms[0] = parmItemID;
objDbAccess.DBOpen();
SqlDataReader dr = objDbAccess.ExecuteReader("Inventory.GetSubItemDetailBySubItemID", parms);
while (dr.Read())
{
var subItemDetail = new SubItemDetailBO();
subItemDetail.SubItemID = int.Parse(dr["SubItemID"].ToString());
subItemDetail.Serial = dr["ItemSerial"].ToString();
subItemDetail.UnitOfMeasureID = int.Parse(dr["UnitOfMeasureID"].ToString());
subItemDetail.SubItemDetailID = int.Parse(dr["SubItemDetailID"].ToString());
subItemDetail.ItemID = int.Parse(dr["ItemID"].ToString());
subItemDetail.QtyForUnit = decimal.Parse(dr["QtyForUnit"].ToString());
subItemDetail.Description = dr["ItemDescription"].ToString();
subItemDetail.UnitOfMeasureName = dr["UnitDescription"].ToString();
list.Add(subItemDetail);
}
return list;
}
catch (Exception ex)
{
throw ex;
}
finally
{
objDbAccess.DBClose();
}
}
public static List<DesignationBO> GetAllDesignations(bool IsActive)
{
List<DesignationBO> DesignationList = new List<DesignationBO>();
DBEgine dbEgine = new DBEgine();
try
{
dbEgine.DBOpen();
SqlParameter[] parms = new SqlParameter[1];
SqlParameter p1 = new SqlParameter();
p1.ParameterName = "@IsActive";
p1.SqlDbType = SqlDbType.Bit;
p1.Direction = ParameterDirection.Input;
p1.Value = IsActive;
parms[0] = p1;
SqlDataReader drDesig = dbEgine.ExecuteReader("UM_GetAllDesignations", parms);
if (drDesig != null && drDesig.HasRows)
{
while (drDesig.Read())
{
DesignationDAL des = new DesignationDAL();
DesignationList.Add(des.FillDesignation(drDesig));
}
}
return DesignationList;
}
catch
{
throw;
}
finally
{
dbEgine.DBClose();
}
}
public DesignationBO GetDesignation(int Id)
{
DBEgine dbEgine = new DBEgine();
DesignationBO des = new DesignationBO();
try
{
dbEgine.DBOpen();
SqlParameter[] parms = new SqlParameter[1];
SqlParameter p1 = new SqlParameter();
p1.ParameterName = "in_DesignationId";
p1.SqlDbType = SqlDbType.Int;
p1.Direction = ParameterDirection.Input;
p1.Value = Id;
parms[0] = p1;
SqlDataReader drDesig = dbEgine.ExecuteReader("UserManagement.UM_LoadDesignationById", parms);
if (drDesig != null && drDesig.HasRows)
{
while (drDesig.Read())
{
des= FillDesignation(drDesig);
}
// this.ScreenList = LoadUserPermissionByUserId();
}
return des;
}
catch
{
throw;
}
finally
{
dbEgine.DBClose();
}
}
public int DeleteUserBranchesDetails(DBEgine dbEgine, int userID)
{
try
{
SqlParameter[] paramArray = new SqlParameter[1];
SqlParameter userIDParam = new SqlParameter();
userIDParam.ParameterName = "@UserID";
userIDParam.SqlDbType = SqlDbType.Int;
userIDParam.Direction = ParameterDirection.Input;
userIDParam.Value = userID;
paramArray[0] = userIDParam;
dbEgine.ExecNonQueryStoredProc("UserManagement.UM_DeleteUserBranchesDetails", paramArray);
return new UserBranchesDetailsBO().BranchID;
}
catch
{
throw;
}
}
public Guid CreateSession(UserSessionBO obj)
{
DBEgine dbEngine = new DBEgine();
try
{
dbEngine.DBOpen();
SqlParameter[] parms = new SqlParameter[3];
SqlParameter p1 = new SqlParameter();
p1.ParameterName = "UserId";
p1.SqlDbType = SqlDbType.Int;
p1.Value = obj.UserID;
parms[0] = p1;
SqlParameter p2 = new SqlParameter();
p2.ParameterName = "LanguageID";
p2.SqlDbType = SqlDbType.Int;
p2.Value = obj.LanguageID;
parms[1] = p2;
SqlParameter p3 = new SqlParameter();
p3.ParameterName = "UserSessionID";
p3.SqlDbType = SqlDbType.UniqueIdentifier;
p3.Direction = ParameterDirection.Output;
parms[2] = p3;
dbEngine.ExecNonQueryStoredProc("UM_CreateUserSession", parms);
return (Guid)p3.Value;
}
catch
{
throw;
}
finally
{
dbEngine.DBClose();
}
}
public List<UserUnlockBO> LoadUserLockHistory(int UserId)
{
DBEgine dbEgine = new DBEgine();
List<UserUnlockBO> LockList = new List<UserUnlockBO>();
try
{
dbEgine.DBOpen();
SqlParameter[] parms = new SqlParameter[1];
SqlParameter p1 = new SqlParameter();
p1.ParameterName = "@UserId";
p1.SqlDbType = SqlDbType.Int;
p1.Direction = ParameterDirection.Input;
p1.Value = UserId;
parms[0] = p1;
SqlDataReader drUser = dbEgine.ExecuteReader("UM_LoadUserLockHistory", parms);
LockList = FillUserUnlockInformation(drUser);
if (LockList != null)
{
return LockList;
}
return null;
}
catch
{
throw;
}
finally
{
dbEgine.DBClose();
}
}
public bool DeleteSubItemDetailByID(DBEgine objDbAccess, int id)
{
try
{
SqlParameter[] parms = new SqlParameter[1];
SqlParameter parmItemID = new SqlParameter();
parmItemID.Value = id;
parmItemID.SqlDbType = SqlDbType.Int;
parmItemID.Direction = ParameterDirection.Input;
parmItemID.ParameterName = "@SubItemID";
parms[0] = parmItemID;
objDbAccess.ExecNonQueryStoredProc("Inventory.DeleteSubItemDetail", parms);
return true;
}
catch (Exception ex)
{
throw ex;
}
}
public bool EditGroup(UserGroupBO obj)
{
bool isUpdate = false;
DBEgine dbEgine = new DBEgine();
dbEgine.DBOpen();
SqlParameter[] parms = new SqlParameter[3];
SqlParameter p1 = new SqlParameter();
p1.ParameterName = "in_groupId";
p1.SqlDbType = SqlDbType.Int;
p1.Direction = ParameterDirection.Input;
p1.Value = obj.GroupId;
parms[0] = p1;
SqlParameter p2 = new SqlParameter();
p2.ParameterName = "in_groupName";
p2.SqlDbType = SqlDbType.NVarChar;
p2.Size = 50;
p2.Direction = ParameterDirection.Input;
p2.Value = obj.GroupName;
parms[1] = p2;
SqlParameter p3 = new SqlParameter();
p3.ParameterName = "in_modifiedUser";
p3.SqlDbType = SqlDbType.Int;
p3.Direction = ParameterDirection.Input;
p3.Value = obj.ModifiedUser;
parms[2] = p3;
dbEgine.ExecNonQueryStoredProc("UM_EditGroup", parms);
isUpdate = true;
dbEgine.DBClose();
return isUpdate;
}
public bool DeleteInvoice(InvoiceHeaderBO invoiceHeader)
{
DBEgine objDbAccess = new DBEgine();
bool result = false;
SqlTransaction tran = null;
try
{
SqlParameter[] parms = new SqlParameter[1];
SqlParameter parmInvoiceID = new SqlParameter();
parmInvoiceID.Value = invoiceHeader.InvoiceID;
parmInvoiceID.SqlDbType = SqlDbType.Int;
parmInvoiceID.Direction = ParameterDirection.Input;
parmInvoiceID.ParameterName = "@InvoiceID";
parms[0] = parmInvoiceID;
objDbAccess.DBOpen(tran);
if (objDbAccess.ExecNonQueryStoredProc("Sales.DeleteInvoices", parms) > 0)
{
result = true;
}
objDbAccess.DBTransAction.Commit();
return result;
}
catch
{
objDbAccess.DBTransAction.Rollback();
throw;
}
finally
{
objDbAccess.DBClose();
}
}
public int SaveDesignation(out int Id, DesignationBO obj)
{
DBEgine dbEgine = new DBEgine();
try
{
dbEgine.DBOpen();
SqlParameter[] parms = new SqlParameter[4];
SqlParameter designationIdParm = new SqlParameter();
designationIdParm.ParameterName = "DesignationId";
designationIdParm.SqlDbType = SqlDbType.Int;
designationIdParm.Direction = ParameterDirection.InputOutput;
designationIdParm.Value = obj.DesignationId;
parms[0] = designationIdParm;
SqlParameter designationParm = new SqlParameter();
designationParm.ParameterName = "Designation";
designationParm.SqlDbType = SqlDbType.NVarChar;
designationParm.Direction = ParameterDirection.Input;
designationParm.Value = obj.DesignationName;
parms[1] = designationParm;
SqlParameter descriptionParm = new SqlParameter();
descriptionParm.ParameterName = "Description";
descriptionParm.SqlDbType = SqlDbType.NVarChar;
descriptionParm.Direction = ParameterDirection.Input;
descriptionParm.Value = obj.Desciption;
parms[2] = descriptionParm;
SqlParameter IsActiveParm = new SqlParameter();
IsActiveParm.ParameterName = "IsActive";
IsActiveParm.SqlDbType = SqlDbType.Bit;
IsActiveParm.Direction = ParameterDirection.Input;
IsActiveParm.Value = obj.IsActive;
parms[3] = IsActiveParm;
dbEgine.ExecNonQueryStoredProc("UM_AddDesignations", parms);
Id = Int32.Parse(designationIdParm.Value.ToString());
return Id;
}
catch
{
throw;
}
finally
{
dbEgine.DBClose();
}
}
public DataSet GetDailySalesReport(DateTime fromDate,DateTime toDate)
{
DBEgine objDbAccess = new DBEgine();
try
{
objDbAccess.DBOpen();
DataSet ds = objDbAccess.ExecuteDataSet("SELECT * FROM Sales.DailySales('"+fromDate.ToShortDateString()+"','"+toDate.ToShortDateString()+"')");
return ds;
}
catch (Exception ex)
{
throw ex;
}
finally
{
objDbAccess.DBClose();
}
}
