public void SaveBankAccount(ref CustomList<CmnBankAccount> BankAccountList)
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
Boolean blnTranStarted = false;
try
{
conManager.BeginTransaction();
ReSetSPName(BankAccountList);
Int32 accountID = BankAccountList[0].AccountID;
blnTranStarted = true;
if (BankAccountList[0].IsAdded)
accountID = Convert.ToInt32(conManager.InsertData(blnTranStarted, BankAccountList));
else
conManager.SaveDataCollectionThroughCollection(blnTranStarted, BankAccountList);
BankAccountList.AcceptChanges();
conManager.CommitTransaction();
blnTranStarted = false;
}
catch (Exception Ex)
{
conManager.RollBack();
throw Ex;
}
finally
{
if (conManager.IsNotNull())
{
conManager.Dispose();
}
}
}
public void SaveCmnDocListTableMapping(ref CustomList<CmnDocListTableMapping> CmnDocListTableMappingList)
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
Boolean blnTranStarted = false;
try
{
conManager.BeginTransaction();
ReSetSPName(CmnDocListTableMappingList);
Int64 TransactionTypeKey = CmnDocListTableMappingList[0].DocListTableMappingID;
blnTranStarted = true;
if (CmnDocListTableMappingList[0].IsAdded)
TransactionTypeKey = Convert.ToInt64(conManager.InsertData(blnTranStarted, CmnDocListTableMappingList));
else
conManager.SaveDataCollectionThroughCollection(blnTranStarted, CmnDocListTableMappingList);
CmnDocListTableMappingList.AcceptChanges();
conManager.CommitTransaction();
blnTranStarted = false;
}
catch (Exception Ex)
{
conManager.RollBack();
throw Ex;
}
finally
{
if (conManager.IsNotNull())
{
conManager.Dispose();
}
}
}
public void SaveWorkFlow(ref CustomList<CmnWorkFlowMaster> CmnWorkFlowMasterList, ref CustomList<CmnWorkFlowDetail> CmnWorkFlowDetailList)
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
Boolean blnTranStarted = false;
try
{
conManager.BeginTransaction();
ReSetSPName(CmnWorkFlowMasterList, CmnWorkFlowDetailList);
workFlowID = CmnWorkFlowMasterList[0].WorkFlowID;
blnTranStarted = true;
if (CmnWorkFlowMasterList[0].IsAdded)
workFlowID = Convert.ToInt32(conManager.InsertData(blnTranStarted, CmnWorkFlowMasterList));
else
conManager.SaveDataCollectionThroughCollection(blnTranStarted, CmnWorkFlowMasterList);
CmnWorkFlowDetailList.ForEach(x => x.WorkFlowID = workFlowID);
conManager.SaveDataCollectionThroughCollection(blnTranStarted, CmnWorkFlowDetailList);
CmnWorkFlowMasterList.AcceptChanges();
CmnWorkFlowDetailList.AcceptChanges();
conManager.CommitTransaction();
blnTranStarted = false;
}
catch (Exception Ex)
{
conManager.RollBack();
throw Ex;
}
finally
{
if (conManager.IsNotNull())
{
conManager.Dispose();
}
}
}
public void SaveBank(ref CustomList<Gen_Bank> BankMasterList, ref CustomList<Bank_Branch> BankBranchList)
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
Boolean blnTranStarted = false;
try
{
conManager.BeginTransaction();
ReSetSPName(BankMasterList, BankBranchList);
Int32 bankKey = BankMasterList[0].BankKey;
blnTranStarted = true;
if (BankMasterList[0].IsAdded)
bankKey = Convert.ToInt32(conManager.InsertData(blnTranStarted, BankMasterList));
else
conManager.SaveDataCollectionThroughCollection(blnTranStarted, BankMasterList);
var bankBranch = (CustomList<Bank_Branch>)BankBranchList;
bankBranch.ForEach(x => x.BankKey = bankKey);
conManager.SaveDataCollectionThroughCollection(blnTranStarted, bankBranch);
BankMasterList.AcceptChanges();
BankBranchList.AcceptChanges();
conManager.CommitTransaction();
blnTranStarted = false;
}
catch (Exception Ex)
{
conManager.RollBack();
throw Ex;
}
finally
{
if (conManager.IsNotNull())
{
conManager.Dispose();
}
}
}
public void SaveItemSegment(ref CustomList<SegmentNames> lstSegmentNames, ref CustomList<SegmentValues> lstSegmentValues)
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
Boolean blnTranStarted = false;
try
{
conManager.BeginTransaction();
ReSetSPName(lstSegmentNames, lstSegmentValues);
Int32 SegNameID = lstSegmentNames[0].SegNameID;
blnTranStarted = true;
if (lstSegmentNames[0].IsAdded)
SegNameID = Convert.ToInt32(conManager.InsertData(blnTranStarted, lstSegmentNames));
else
conManager.SaveDataCollectionThroughCollection(blnTranStarted, lstSegmentNames);
var SegmentValues = (CustomList<SegmentValues>)lstSegmentValues;
SegmentValues.ForEach(x => x.SegNameID = SegNameID);
conManager.SaveDataCollectionThroughCollection(blnTranStarted, SegmentValues);
lstSegmentNames.AcceptChanges();
lstSegmentValues.AcceptChanges();
conManager.CommitTransaction();
blnTranStarted = false;
}
catch (Exception Ex)
{
conManager.RollBack();
throw Ex;
}
finally
{
if (conManager.IsNotNull())
{
conManager.Dispose();
}
}
}
public void SaveDocListFormat(ref CustomList<CmnDocListFormat> DocListFormatList, ref CustomList<CmnDocListFormatDetail> DocListFormatDetailList)
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
Boolean blnTranStarted = false;
try
{
conManager.BeginTransaction();
ReSetSPName(DocListFormatList, DocListFormatDetailList);
Int32 docListFormatKey = DocListFormatList[0].DocListFormatID;
blnTranStarted = true;
if (DocListFormatList[0].IsAdded)
docListFormatKey = Convert.ToInt32(conManager.InsertData(blnTranStarted, DocListFormatList));
else
conManager.SaveDataCollectionThroughCollection(blnTranStarted, DocListFormatList);
var docListFormatDetail = (CustomList<CmnDocListFormatDetail>)DocListFormatDetailList;
docListFormatDetail.ForEach(x => x.DocListFormatID = docListFormatKey);
conManager.SaveDataCollectionThroughCollection(blnTranStarted, docListFormatDetail);
DocListFormatList.AcceptChanges();
DocListFormatDetailList.AcceptChanges();
conManager.CommitTransaction();
blnTranStarted = false;
}
catch (Exception Ex)
{
conManager.RollBack();
throw Ex;
}
finally
{
if (conManager.IsNotNull())
{
conManager.Dispose();
}
}
}
public void SaveStockTransaction(ref CustomList<StockTransactionMaster> lstStockTransactionMaster, ref CustomList<StockTransactionDetail> lstStockTransactionDetail)
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
Boolean blnTranStarted = false;
try
{
conManager.BeginTransaction();
ReSetSPName(lstStockTransactionMaster, lstStockTransactionDetail);
GetNewStockTransaction(ref conManager, ref lstStockTransactionMaster);
Int64 StockTransID = lstStockTransactionMaster[0].StockTransID;
blnTranStarted = true;
if (lstStockTransactionMaster[0].IsAdded)
StockTransID = Convert.ToInt32(conManager.InsertData(blnTranStarted, lstStockTransactionMaster));
else
conManager.SaveDataCollectionThroughCollection(blnTranStarted, lstStockTransactionMaster);
lstStockTransactionDetail.ForEach(x => x.StockTransID = StockTransID);
conManager.SaveDataCollectionThroughCollection(blnTranStarted, lstStockTransactionDetail);
lstStockTransactionMaster.AcceptChanges();
lstStockTransactionDetail.AcceptChanges();
conManager.CommitTransaction();
blnTranStarted = false;
}
catch (Exception Ex)
{
conManager.RollBack();
throw Ex;
}
finally
{
if (conManager.IsNotNull())
{
conManager.Dispose();
}
}
}
public void SaveHKEntry(ref CustomList<HouseKeepingValue> HKList, ref CustomList<HousekeepingHierarchy> lstChild)
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
Boolean blnTranStarted = false;
try
{
conManager.BeginTransaction();
ReSetSPName(HKList, lstChild);
blnTranStarted = true;
Int32 HKID = HKList[0].HKID;
blnTranStarted = true;
if (HKList[0].IsAdded)
HKID = Convert.ToInt32(conManager.InsertData(blnTranStarted, HKList));
else
conManager.SaveDataCollectionThroughCollection(blnTranStarted, HKList);
lstChild.ForEach(x => x.HKID = HKID);
conManager.SaveDataCollectionThroughCollection(blnTranStarted, lstChild);
HKList.AcceptChanges();
lstChild.AcceptChanges();
conManager.CommitTransaction();
blnTranStarted = false;
conManager.Dispose();
}
catch (Exception Ex)
{
conManager.RollBack();
throw Ex;
}
finally
{
if (conManager.IsNotNull())
{
conManager.Dispose();
}
}
}
public void SaveContactInfo(ref CustomList<ContactInfo> ContactInfoList, ref CustomList<ContactType> ContactTypeList, ref CustomList<ContactTypeChild> ContactTypeChildList, ref CustomList<ContactDetail> lstContactDetail)
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
Boolean blnTranStarted = false;
try
{
conManager.BeginTransaction();
ReSetSPName(ContactInfoList, ContactTypeList, ContactTypeChildList);
Int32 contactID = ContactInfoList[0].ContactID;
blnTranStarted = true;
if (ContactInfoList[0].IsAdded)
{
contactID = Convert.ToInt32(conManager.InsertData(blnTranStarted, ContactInfoList));
ContactInfoList[0].ContactID = contactID;
}
else
conManager.SaveDataCollectionThroughCollection(blnTranStarted, ContactInfoList);
foreach (ContactType cT in ContactTypeList)
{
CustomList<ContactType> ContactType_List = new CustomList<ContactType>();
if (cT.IsAdded)
{
Int32 contactTypeID = 0;
ContactType_List.Add(cT);
ContactType_List.InsertSpName = "spInsertContactType";
contactTypeID = Convert.ToInt32(conManager.InsertData(blnTranStarted, ContactType_List));
cT.ContactTypeID = contactTypeID;
}
if (cT.IsModified)
{
cT.SetModified();
ContactType_List.Add(cT);
ContactType_List.UpdateSpName = "spUpdateContactType";
conManager.SaveDataCollectionThroughCollection(blnTranStarted, ContactType_List);
}
}
CustomList<ContactDetail> ContactDetailList = new CustomList<ContactDetail>();
foreach (ContactType cT in ContactTypeList)
{
if (cT.IsChecked)
{
ContactDetail contactDetail = new ContactDetail();
contactDetail.ContactTypeID = cT.ContactTypeID;
contactDetail.ContactID = contactID;
ContactDetailList.Add(contactDetail);
}
}
foreach (ContactDetail cD in lstContactDetail)
{
ContactDetail obj = ContactDetailList.Find(f => f.ContactTypeID == cD.ContactTypeID);
if (obj.IsNotNull())
obj.SetModified();
else
{
cD.Delete();
ContactDetailList.Add(cD);
}
}
ReSetSPName(ContactDetailList);
conManager.SaveDataCollectionThroughCollection(blnTranStarted, ContactDetailList);
ContactInfoList.AcceptChanges();
ContactTypeList.AcceptChanges();
ContactTypeChildList.AcceptChanges();
ContactDetailList.AcceptChanges();
conManager.CommitTransaction();
blnTranStarted = false;
}
catch (Exception Ex)
{
conManager.RollBack();
throw Ex;
}
finally
{
if (conManager.IsNotNull())
{
conManager.Dispose();
}
}
}
//End
//Search Voucher
//public CustomList<Acc_Voucher> GetAllAcc_VoucherSearch(string searchStr, string blank)
//{
// return Acc_Voucher.GetAllAcc_VoucherSearch(searchStr, blank);
//}
//end
public void SavePFVoucher(ref CustomList<Acc_Voucher> AccVoucherList, ref CustomList<Acc_VoucherDet> AccVoucherDetList, string prifix)
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
Boolean blnTranStarted = false;
try
{
blnTranStarted = true;
conManager.BeginTransaction();
ReSetSPName(ref AccVoucherList, ref AccVoucherDetList);
if (AccVoucherList[0].VoucherNo.IsNullOrEmpty())
{
GetNewVoucherID(ref conManager, blnTranStarted, ref AccVoucherList, prifix);
}
else
{
string[] items = AccVoucherList[0].VoucherNo.Split('-');
if (prifix != items[0])
{
string prifix1 = prifix + "-" + items[1];
voucherID = prifix1;
AccVoucherList[0].VoucherNo = prifix1;
}
else
voucherID = AccVoucherList[0].VoucherNo;
}
blnTranStarted = true;
if (AccVoucherList[0].IsAdded)
{
object scope_Identity = conManager.InsertData(blnTranStarted, AccVoucherList);
AccVoucherList[0].VoucherKey = Convert.ToInt64(scope_Identity);
}
else
{
conManager.SaveDataCollectionThroughCollection(blnTranStarted, AccVoucherList);
}
CustomList<Acc_VoucherDet> AddedVoucherDetList = AccVoucherDetList.FindAll(f => f.IsAdded);
foreach (Acc_VoucherDet aVD in AddedVoucherDetList)
{
aVD.VoucherKey = AccVoucherList[0].VoucherKey;
}
conManager.SaveDataCollectionThroughCollection(blnTranStarted, AccVoucherDetList);
conManager.CommitTransaction();
AccVoucherList.AcceptChanges();
AccVoucherDetList.AcceptChanges();
}
catch (Exception Ex)
{
conManager.RollBack();
throw Ex;
}
finally
{
if (conManager.IsNotNull())
{
blnTranStarted = false;
conManager.Dispose();
}
}
}
