internal int GetMonthlyCollectionAmount(int monthInNumber)
{
int nowYear = DateTime.Now.Year;
int totalAmount = 0;
try
{
using (_Context = new ERPSSL_Marketing_Entities())
{
var query = (from m in _Context.MRK_Transaction
where m.CollectionDate.Value.Month == monthInNumber && m.CollectionDate.Value.Year == nowYear
select m);
List <MRK_Transaction> aMRK_Transaction = new List <MRK_Transaction>();
aMRK_Transaction = query.ToList();
foreach (MRK_Transaction transaction in aMRK_Transaction)
{
totalAmount = totalAmount + Convert.ToInt32(transaction.CollectionAmount);
}
return(totalAmount);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static List <string> SearchClientName(string prefixText, int count)
{
using (var _context = new ERPSSL_Marketing_Entities())
{
var allClient = from m in _context.MRK_MarketingInfo
where ((m.Client.Contains(prefixText)) && m.StageId <= 2)
select m;
List <String> clientList = new List <String>();
foreach (var clientName in allClient)
{
clientList.Add(clientName.Client);
}
if (clientList.Count == 0)
{
availableList = 0;
}
else
{
availableList = 1;
}
return(clientList);
}
}
internal List <int> getTaskIdList(int workOrderId)
{
using (var _context = new ERPSSL_Marketing_Entities())
{
return((from t in _context.MRK_Task_Details
where t.WorkOrderId == workOrderId
select t.TaskDetails_Id).ToList());
}
}
internal int SaveWorkOrderToTransaction(MRK_Transaction aMRK_Transaction)
{
using (_Context = new ERPSSL_Marketing_Entities())
{
_Context.MRK_Transaction.AddObject(aMRK_Transaction);
_Context.SaveChanges();
return(1);
}
}
internal int SaveWordOrderInfo(MRK_WorkOrder aMRK_WorkOrder)
{
using (_Context = new ERPSSL_Marketing_Entities())
{
_Context.MRK_WorkOrder.AddObject(aMRK_WorkOrder);
_Context.SaveChanges();
return(aMRK_WorkOrder.WoID);
}
}
internal List <MRK_Task_Details> GetTaskDetailsByWorkOrderNo(int OrderId, string OCODE)
{
using (var _context = new ERPSSL_Marketing_Entities())
{
return((from t in _context.MRK_Task_Details
where t.WorkOrderId == OrderId && t.OCode == OCODE
select t).ToList());
}
}
public static List <string> SearchClientName2(string prefixText, int count)
{
using (var _context = new ERPSSL_Marketing_Entities())
{
var allClient = from m in _context.MRK_MarketingInfo
where ((m.Client.Contains(prefixText)))
select m;
List <String> clientList = new List <String>();
foreach (var clientName in allClient)
{
clientList.Add(clientName.Client);
}
return(clientList);
}
}
internal int Savereference(MRK_Reference aMRK_Reference)
{
try
{
using (var _context = new ERPSSL_Marketing_Entities())
{
_context.MRK_Reference.AddObject(aMRK_Reference);
_context.SaveChanges();
return(aMRK_Reference.ReferenceId);
}
}
catch (Exception ex)
{
throw ex;
}
}
internal int Saveproject(MRK_Project aMRK_Project)
{
try
{
using (var _context = new ERPSSL_Marketing_Entities())
{
_context.MRK_Project.AddObject(aMRK_Project);
_context.SaveChanges();
return(aMRK_Project.ProjectId);
}
}
catch (Exception ex)
{
throw ex;
}
}
internal List <int> GetNumberOfOnGoingOrder()
{
try
{
using (_Context = new ERPSSL_Marketing_Entities())
{
var query = (from w in _Context.MRK_WorkOrder
select w.WoID);
return(query.ToList());
}
}
catch (Exception ex)
{
throw ex;
}
}
internal int GetWorkOrderId(int marketingInfoId)
{
try
{
using (var _context = new ERPSSL_Marketing_Entities())
{
return((from m in _context.MRK_MarketingInfo
join w in _context.MRK_WorkOrder on m.MarketingInfoId equals w.MarketingInfoId
where m.MarketingInfoId == marketingInfoId
select w.WoID).FirstOrDefault());
}
}
catch (Exception)
{
throw;
}
}
internal List <MRK_Reference> Get_AllReferenceList(string OCODE)
{
try
{
using (var _context = new ERPSSL_Marketing_Entities())
{
var ListItem = (from r in _context.MRK_Reference
where r.OCODE == OCODE
select r);
return(ListItem.ToList());
}
}
catch (Exception ex)
{
throw ex;
}
}
internal List <MRK_Transaction> GetTotalPreCollectionAmount(int preMonth, int preYear)
{
try
{
using (_Context = new ERPSSL_Marketing_Entities())
{
var query = (from t in _Context.MRK_Transaction
where t.CollectionDate.Value.Month == preMonth && t.CollectionDate.Value.Year == preYear
select t);
return(query.ToList());
}
}
catch (Exception ex)
{
throw ex;
}
}
internal List <LC_InputType> GettAllTask()
{
using (_context = new ERPSSL_Marketing_Entities())
{
try
{
var query = (from l in _context.LC_InputType
where l.Use_Dept == "Marketing Task"
select l);
return(query.ToList());
}
catch (Exception ex)
{
throw ex;
}
}
}
internal List <MRK_MarketingInfo> GetTotalPreVisit(int preMonth, int preYear)
{
try
{
using (_Context = new ERPSSL_Marketing_Entities())
{
var query = (from m in _Context.MRK_MarketingInfo
where m.VisitDate.Value.Month == preMonth && m.VisitDate.Value.Year == preYear
select m);
return(query.ToList());
}
}
catch (Exception ex)
{
throw ex;
}
}
internal List <int> GetNumberOfUpComingOrder()
{
try
{
using (_Context = new ERPSSL_Marketing_Entities())
{
var query = (from m in _Context.MRK_MarketingInfo
where !(_Context.MRK_WorkOrder.Any(w => w.MarketingInfoId == m.MarketingInfoId))
select m.MarketingInfoId);
return(query.ToList());
}
}
catch (Exception ex)
{
throw ex;
}
}
internal int SaveAMCInfo(MRK_AMC aMRK_AMC)
{
try
{
using (_Context = new ERPSSL_Marketing_Entities())
{
_Context.MRK_AMC.AddObject(aMRK_AMC);
_Context.SaveChanges();
return(1);
//return aMRK_WorkOrder.WoID; // If want to return last id from table
}
}
catch (Exception ex)
{
throw ex;
}
}
internal List <string> Get_ClientWiseList(string OCODE)
{
try
{
using (var _context = new ERPSSL_Marketing_Entities())
{
var ListItem = (from w in _context.MRK_WorkOrder
join m in _context.MRK_MarketingInfo on w.MarketingInfoId equals m.MarketingInfoId
where w.OCODE == OCODE
select m.Client);
return(ListItem.ToList());
}
}
catch (Exception)
{
throw;
}
}
internal List <MarketingWorkOrderTransaction> GetClientWiseTransaction(string OCODE, string clientName)
{
try
{
using (var _context = new ERPSSL_Marketing_Entities())
{
var _OCode = new SqlParameter("@OCODE", OCODE);
var _ClientName = new SqlParameter("@ClientName", clientName);
string SP_SQL = "MRK_RPT_CollectionByClient @OCODE, @ClientName";
return((_context.ExecuteStoreQuery <MarketingWorkOrderTransaction>(SP_SQL, _OCode, _ClientName)).ToList());
}
}
catch (Exception ex)
{
throw ex;
}
}
internal List <MarketingTaskDetails> GetAllInformationOfTask(string OCODE)
{
try
{
using (var _context = new ERPSSL_Marketing_Entities())
{
var _OCode = new SqlParameter("@OCODE", OCODE);
string SP_SQL = "MRK_RPT_AllTaskDetails @OCODE";
return((_context.ExecuteStoreQuery <MarketingTaskDetails>(SP_SQL, _OCode)).ToList());
}
}
catch (Exception ex)
{
throw ex;
}
}
internal List <int> GetMidLevelClient()
{
try
{
using (_Context = new ERPSSL_Marketing_Entities())
{
var query = (from m in _Context.MRK_MarketingInfo
where m.StageId == 2
select m.MarketingInfoId);
return(query.ToList());
}
}
catch (Exception ex)
{
throw ex;
}
}
internal List <MarketingProjectStage> GetAllInformationOfClientVisit(string OCODE, DateTime FromDate, DateTime ToDate)
{
try
{
using (var _context = new ERPSSL_Marketing_Entities())
{
var _OCode = new SqlParameter("@OCODE", OCODE);
var _FromDate = new SqlParameter("@FromDate", FromDate);
var _ToDate = new SqlParameter("@ToDate", ToDate);
string SP_SQL = "MRK_RPT_ClientVisitByDate @OCODE, @FromDate, @ToDate ";
return((_context.ExecuteStoreQuery <MarketingProjectStage>(SP_SQL, _OCode, _FromDate, _ToDate)).ToList());
}
}
catch (Exception ex)
{
throw ex;
}
}
internal List <MarketingWorkOrderTransaction> GetCollectionInformationByDate(string OCODE, DateTime FromDate, DateTime ToDate)
{
try
{
using (var _context = new ERPSSL_Marketing_Entities())
{
var _OCode = new SqlParameter("@OCODE", OCODE);
var _FromDate = new SqlParameter("@FromDate", FromDate);
var _ToDate = new SqlParameter("@ToDate", ToDate);
string SP_SQL = "MRK_RPT_CollectionByDate @OCODE, @FromDate, @ToDate ";
return((_context.ExecuteStoreQuery <MarketingWorkOrderTransaction>(SP_SQL, _OCode, _FromDate, _ToDate)).ToList());
}
}
catch (Exception ex)
{
throw ex;
}
}
internal List <MarketingTaskDetails> GetIndividualInformationOfTask(string OCODE, string clientName)
{
try
{
using (var _context = new ERPSSL_Marketing_Entities())
{
var _OCode = new SqlParameter("@OCODE", OCODE);
var _Client = new SqlParameter("@Client", clientName);
string SP_SQL = "MRK_RPT_IndividualTaskDetails @OCODE, @Client";
return((_context.ExecuteStoreQuery <MarketingTaskDetails>(SP_SQL, _OCode, _Client)).ToList());
}
}
catch (Exception ex)
{
throw ex;
}
}
public void getPrevousTransactionInfoById(string workOrderId)
{
int transactionWorkOrderId = Convert.ToInt32(workOrderId);
using (var _Context = new ERPSSL_Marketing_Entities())
{
var collectionAmount = from t in _Context.MRK_Transaction
where t.WorkOrderId == transactionWorkOrderId
select t;
foreach (var camount in collectionAmount)
{
paidAmount = paidAmount + Convert.ToDecimal(camount.CollectionAmount);
}
paidAmountLabel.Text = paidAmount.ToString("0.00");
dueAmountLabel.Text = (Convert.ToDecimal(totalAmountLabel.Text) - paidAmount).ToString("0.00");
}
}
internal int UpdateTaskDetails(MRK_Task_Details aMRK_Task_Details, int ID)
{
try
{
using (var _context = new ERPSSL_Marketing_Entities())
{
var TaskDetails = _context.MRK_Task_Details.FirstOrDefault(x => x.TaskDetails_Id == ID);
TaskDetails.Date = aMRK_Task_Details.Date;
TaskDetails.Remarks = aMRK_Task_Details.Remarks;
TaskDetails.Comments = aMRK_Task_Details.Comments;
TaskDetails.EditDate = aMRK_Task_Details.EditDate;
TaskDetails.EditUser = aMRK_Task_Details.EditUser;
_context.SaveChanges();
return(1);
}
}
catch (Exception)
{
throw;
}
}
public static List <string> SearchClientName(string prefixText, int count)
{
using (var _context = new ERPSSL_Marketing_Entities())
{
var allClient = from w in _context.MRK_WorkOrder
join m in _context.MRK_MarketingInfo on w.MarketingInfoId equals m.MarketingInfoId
where w.AMCDAte <= DateTime.Now &&
((m.Client.Contains(prefixText)))
select m;
List <String> clientList = new List <String>();
if (allClient.ToList().Count > 0)
{
clientList.AddRange(allClient.Select(x => x.Client).AsEnumerable());
}
return(clientList);
}
}
internal int GetMonthlyVisitStatus(int monthInNumber)
{
int nowYear = DateTime.Now.Year;
try
{
using (_Context = new ERPSSL_Marketing_Entities())
{
var query = (from m in _Context.MRK_MarketingInfo
where m.VisitDate.Value.Month == monthInNumber && m.VisitDate.Value.Year == nowYear
select m);
List <MRK_MarketingInfo> aMarketingInfo = new List <MRK_MarketingInfo>();
aMarketingInfo = query.ToList();
return(aMarketingInfo.Count);
}
}
catch (Exception ex)
{
throw ex;
}
}
