public ID Save(UserFunctionality oUserFunctionality) { bool bIsExist = false; try { if (oUserFunctionality.IsNew) { string QueryString = "SELECT COUNT(*) FROM Function_permission_Table WHERE UFID=" + oUserFunctionality.UFID + " AND user_id=" + oUserFunctionality.User_ID; bIsExist = ExecuteQueryFunctions.ExeSclr(_conn, QueryString); if (!bIsExist) { BusinessObject.Factory.SetID(oUserFunctionality, new ID(ExecuteQueryFunctions.GetNewID(_conn, "SELECT MAX(UFPID) FROM Function_permission_Table"))); string QueryString2 = "INSERT INTO Function_permission_Table (UFPID,UFID,user_id,DBUserID,DBSDT)" + "VALUES(" + oUserFunctionality.ObjectID + "," + oUserFunctionality.UFID + "," + oUserFunctionality.User_ID + "," + EMSGlobal._nCurrentUserID + ",'" + DateTime.Now + "')"; ExecuteQueryFunctions.ExeNonQuery(_conn, QueryString2); } } BusinessObject.Factory.SetObjectState(oUserFunctionality, ObjectState.Saved); } catch (Exception e) { throw new ServiceException(e.Message, e); } return(oUserFunctionality.ID); }
public ID Save(BankAccount oBankAccount) { try { if (oBankAccount.IsNew) { BusinessObject.Factory.SetID(oBankAccount, new ID(ExecuteQueryFunctions.GetNewID(_conn, "SELECT MAX(ObjectID) FROM [tbl_bankAccount]"))); string QueryString = "INSERT INTO [tbl_bankAccount] (ObjectID,bankID,branchName,bankName,accountNumber,accountType,currentBalance,GLhead,DBUserID,DBSDT)" + " VALUES (" + oBankAccount.ObjectID + "," + oBankAccount.bankID + ",'" + oBankAccount.branchName + "','" + oBankAccount.bankName + "','" + oBankAccount.accountNumber + "'," + (int)oBankAccount.EnumAccountType + "," + oBankAccount.currentBalance + ",'" + oBankAccount.GLhead + "'," + EMSGlobal._nCurrentUserID + ",'" + DateTime.Now + "')"; ExecuteQueryFunctions.ExeNonQuery(_conn, QueryString); } BusinessObject.Factory.SetObjectState(oBankAccount, ObjectState.Saved); } catch (Exception e) { throw new Exception(e.Message, e); } return(oBankAccount.ID); }
public ID Save(NewUser oNewUser) { try { if (oNewUser.IsNew) { BusinessObject.Factory.SetID(oNewUser, new ID(ExecuteQueryFunctions.GetNewID(_conn, "SELECT MAX(user_id) FROM User_Table"))); string sSN = "0000"; sSN = sSN.Substring(0, sSN.Length - oNewUser.ObjectID.ToString().Length) + oNewUser.ObjectID; oNewUser.user_name = "User" + sSN; oNewUser.user_pass = "******"; oNewUser.user_status = EnumUserStatus.Active; oNewUser.user_code = (int)oNewUser.user_type + oNewUser.ObjectID.ToString(); string QueryString2 = "INSERT INTO User_Table ([user_id],[brn_id],[user_code],[user_fst_name],[user_lst_name],[user_name_ini],[user_name],[user_pass],[user_type],[user_islogon],[user_lock],[user_status],[OwnerName],[OwnerID],[DBSDT])" + "VALUES(" + oNewUser.ObjectID + "," + "0,'" + oNewUser.user_code + "','" + oNewUser.user_fst_name + "','" + oNewUser.user_lst_name + "','" + oNewUser.user_name + "','" + oNewUser.user_name + "','" + oNewUser.user_pass + "'," + (int)oNewUser.user_type + ",'" + oNewUser.user_islogon + "','" + oNewUser.user_lock + "'," + (int)oNewUser.user_status + ",'" + EMSGlobal._sCurrenUserName + "'," + EMSGlobal._nCurrentUserID + ",'" + DateTime.Now + "')"; ExecuteQueryFunctions.ExeNonQuery(_conn, QueryString2); } BusinessObject.Factory.SetObjectState(oNewUser, ObjectState.Saved); } catch (Exception e) { throw new ServiceException(e.Message, e); } return(oNewUser.ID); }
public ID Save(ManuInterface oManuInterface) { try { if (oManuInterface.IsNew) { BusinessObject.Factory.SetID(oManuInterface, new ID(ExecuteQueryFunctions.GetNewID(_conn, "SELECT MAX(Menu_id) FROM Menu_Table"))); //ManuInterfaceDA.Insert(conn, oManuInterface); } //else //{ // ManuInterfaceDA.Update(conn, oManuInterface); //} //conn.Close(); BusinessObject.Factory.SetObjectState(oManuInterface, ObjectState.Saved); } catch (Exception e) { throw new ServiceException(e.Message); } return(oManuInterface.ID); }
public ID Save(AddBranch oAddBranch) { bool _isBranchExist = false; try { if (oAddBranch.IsNew) { string QueryString = "SELECT * FROM tbl_Branchs WHERE brn_title='" + oAddBranch.brn_title + "'"; _isBranchExist = ExecuteQueryFunctions.ExeIsExist(QueryString); if (!_isBranchExist) { BusinessObject.Factory.SetID(oAddBranch, new ID(ExecuteQueryFunctions.GetNewID(_conn, "SELECT MAX(brn_id) FROM tbl_Branchs"))); string QueryString2 = "INSERT INTO tbl_Branchs (brn_id,brn_type,brn_title,brn_location,DBUserID,DBSDT)" + "VALUES(" + oAddBranch.ObjectID + "," + (int)oAddBranch.ebrn_type + ",'" + oAddBranch.brn_title + "','" + oAddBranch.brn_location + "'," + EMSGlobal._nCurrentUserID + ",'" + DateTime.Now + "')"; ExecuteQueryFunctions.ExeNonQuery(_conn, QueryString2); } else { throw new ServiceException("This Title Already Exist."); } } BusinessObject.Factory.SetObjectState(oAddBranch, ObjectState.Saved); } catch (Exception e) { throw new ServiceException(e.Message, e); } return(oAddBranch.ID); }