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);
}
