public List <SubsidiaryInfo> GetSubInfo()
{
List <SubsidiaryType> subTypeInfo = _subsidiaryTypeAppService.All().ToList();
List <SubsidiaryInfo> subInfo = _subsidiaryInfoAppService.All().ToList();
var subsidiaryInfo = from st in subTypeInfo
join si in subInfo
on st.TypeCode equals si.SubType
join sie in _subsidiaryExtSevevice.All().ToList()
on si.SubCode equals sie.SubCode
select new
{
SubCode = si.SubCode,
SubName = si.SubName,
SubType = st.SubType,
SubCategory = sie.SubCategory
};
List <SubsidiaryInfo> sInfos = new List <SubsidiaryInfo>();
foreach (var item in subsidiaryInfo)
{
SubsidiaryInfo sInfo = new SubsidiaryInfo();
sInfo.SubCode = item.SubCode;
sInfo.SubName = item.SubName;
sInfo.SubType = item.SubType;
sInfo.SubCategory = item.SubCategory;
sInfos.Add(sInfo);
}
return(sInfos);
}
public ActionResult SaveSubsidary(SubsidiaryInfo subsidiaryInfo, SubsidiaryInfo_Ext SubsisiaryExt, List <SubsidiaryInfo_Ext> SubsisiaryExtList)
{
try
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("Subsidiary_Insert"))
{
return(Json("X", JsonRequestBehavior.AllowGet));
}
if (SubsisiaryExtList != null)
{
foreach (var item in SubsisiaryExtList)
{
item.SubCode = SubsisiaryExt.SubCode;
item.SubCategory = SubsisiaryExt.SubCategory;
item.Tel = SubsisiaryExt.Tel;
item.SubEmail = SubsisiaryExt.SubEmail;
item.Fax = SubsisiaryExt.Fax;
item.OpenBal = SubsisiaryExt.OpenBal;
item.OpenDate = SubsisiaryExt.OpenDate;
item.TIN = SubsisiaryExt.TIN;
item.BIN = SubsisiaryExt.BIN;
item.CountryCode = SubsisiaryExt.CountryCode;
item.VATRegNo = SubsisiaryExt.VATRegNo;
_subsidiaryExtSevevice.Add(item);
}
_subsidiaryExtSevevice.Save();
}
else if (SubsisiaryExt != null)
{
SubsidiaryInfo_Ext subsidiaryExt = new SubsidiaryInfo_Ext();
subsidiaryExt.SubTypeExtID = SubsisiaryExt.SubTypeExtID;
subsidiaryExt.SubCode = SubsisiaryExt.SubCode;
subsidiaryExt.SubCategory = SubsisiaryExt.SubCategory;
subsidiaryExt.Tel = SubsisiaryExt.Tel;
subsidiaryExt.SubEmail = SubsisiaryExt.SubEmail;
subsidiaryExt.Fax = SubsisiaryExt.Fax;
subsidiaryExt.OpenBal = SubsisiaryExt.OpenBal;
subsidiaryExt.OpenDate = SubsisiaryExt.OpenDate;
subsidiaryExt.TIN = SubsisiaryExt.TIN;
subsidiaryExt.BIN = SubsisiaryExt.BIN;
subsidiaryExt.CountryCode = SubsisiaryExt.CountryCode;
subsidiaryExt.VATRegNo = SubsisiaryExt.VATRegNo;
_subsidiaryExtSevevice.Add(subsidiaryExt);
_subsidiaryExtSevevice.Save();
}
SubOpenBal subOpnBal = new SubOpenBal();
subOpnBal.SubCode = subsidiaryInfo.SubCode;
subOpnBal.FinYear = Session["FinYear"].ToString();
subOpnBal.OpenBal = Convert.ToDouble(SubsisiaryExt.OpenBal);
subOpnBal.BranchCode = Session["BranchCode"].ToString();
subOpnBal.ProjCode = Session["ProjCode"].ToString();
_SubOpenBalService.Add(subOpnBal);
_subsidiaryInfoAppService.Add(subsidiaryInfo);
_subsidiaryInfoAppService.Save();
_SubOpenBalService.Save();
TransactionLogService.SaveTransactionLog(_transactionLogService, "Subsidiary", "Save", subsidiaryInfo.SubCode, Session["UserName"].ToString());
return(Json("1", JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
public ActionResult UpdateSubsidiary(SubsidiaryInfo subsidiaryInfo, SubsidiaryInfo_Ext SubExt, List <SubsidiaryInfo_Ext> SubsisiaryExtList)
{
using (var transaction = new TransactionScope())
{
try
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("Subsidiary_Update"))
{
return(Json("U", JsonRequestBehavior.AllowGet));
}
if (subsidiaryInfo.SubGrp == null)
{
subsidiaryInfo.SubGrp = "";
}
_subsidiaryExtSevevice.All().ToList().Where(y => y.SubCode.Trim() == SubExt.SubCode).ToList().ForEach(x => _subsidiaryExtSevevice.Delete(x));
if (SubsisiaryExtList != null)
{
foreach (var item in SubsisiaryExtList)
{
item.SubTypeExtID = SubExt.SubTypeExtID;
item.SubCode = SubExt.SubCode;
item.SubCategory = SubExt.SubCategory;
item.Tel = SubExt.Tel;
item.SubEmail = SubExt.SubEmail;
item.Fax = SubExt.Fax;
item.OpenBal = SubExt.OpenBal;
item.OpenDate = SubExt.OpenDate;
item.TIN = SubExt.TIN;
item.BIN = SubExt.BIN;
item.VATRegNo = SubExt.VATRegNo;
item.CountryCode = SubExt.CountryCode;
_subsidiaryExtSevevice.Add(item);
}
_subsidiaryExtSevevice.Save();
}
else if (SubExt != null)
{
SubsidiaryInfo_Ext subsidiaryExt = new SubsidiaryInfo_Ext();
subsidiaryExt.SubTypeExtID = SubExt.SubTypeExtID;
subsidiaryExt.SubCode = SubExt.SubCode;
subsidiaryExt.SubCategory = SubExt.SubCategory;
subsidiaryExt.Tel = SubExt.Tel;
subsidiaryExt.SubEmail = SubExt.SubEmail;
subsidiaryExt.Fax = SubExt.Fax;
subsidiaryExt.OpenBal = SubExt.OpenBal;
subsidiaryExt.OpenDate = SubExt.OpenDate;
subsidiaryExt.TIN = SubExt.TIN;
subsidiaryExt.BIN = SubExt.BIN;
subsidiaryExt.CountryCode = SubExt.CountryCode;
subsidiaryExt.VATRegNo = SubExt.VATRegNo;
_subsidiaryExtSevevice.Add(subsidiaryExt);
_subsidiaryExtSevevice.Save();
}
SubOpenBal subOpnBal = _SubOpenBalService.All().Where(s => s.SubCode == subsidiaryInfo.SubCode).FirstOrDefault();
if (subOpnBal != null)
{
subOpnBal.OpenBal = Convert.ToDouble(SubExt.OpenBal);
_SubOpenBalService.Update(subOpnBal);
_SubOpenBalService.Save();
}
else
{
SubOpenBal subOBal = new SubOpenBal();
subOBal.SubCode = subsidiaryInfo.SubCode;
subOBal.FinYear = Session["FinYear"].ToString();
subOBal.OpenBal = Convert.ToDouble(SubExt.OpenBal);
subOBal.BranchCode = Session["BranchCode"].ToString();
subOBal.ProjCode = Session["ProjCode"].ToString();
_SubOpenBalService.Add(subOBal);
_SubOpenBalService.Save();
}
_subsidiaryInfoAppService.Update(subsidiaryInfo);
_subsidiaryInfoAppService.Save();
TransactionLogService.SaveTransactionLog(_transactionLogService, "Subsidiary", "Update", subsidiaryInfo.SubCode, Session["UserName"].ToString());
transaction.Complete();
return(Json("1", JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
transaction.Dispose();
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
}
