public List <Sell.Report.AmaniDeliveredReportViewModel> GetDeliveredReport(int AGNID)
{
DataLayer.AtsTotalNewDataContext context = new DataLayer.AtsTotalNewDataContext();
var Result = context.ExecuteQuery <Sell.Report.AmaniDeliveredReportViewModel>("execute sale.STP_T000500RP;50 0,0,'','',''," + AGNID);
return(Result.ToList());
}
public ActionResult GetAgentName(int agentId)
{
DataLayer.AtsTotalNewDataContext context = new DataLayer.AtsTotalNewDataContext();
var agn = context.T00050002s.Where(p => p.AGNID == agentId).FirstOrDefault();
return(Content(agn.AGNCode + " , " + agn.AGNDesc));
}
public int Insert(LendingCarsModel model)
{
int Id = 0;
DataLayer.AtsTotalNewDataContext context = new DataLayer.AtsTotalNewDataContext();
string sal = (Core.StaticData.DateNow.Date.Split('/')[0]).Substring(2);
string DateA = model.DateA;
int F_AgnID = (int)model.F_AgnID;
int? FlgTaahod = (model.FlgTaahod == true) ? 1 : 0;
string sql = @"DECLARE @Out int
EXEC [sale].[STP_T00050061];1
@sal ={0},
@DateA ={1},
@F_AgnID= {2},
@FlgTaahod ={3},
@Out = @Out OUTPUT
SELECT @Out as N'@Out'";
Id = context.ExecuteQuery <int>(sql,
sal,
DateA,
F_AgnID,
FlgTaahod).FirstOrDefault();
return(Id);
}
public ActionResult getsnapshotviwer()
{
if (Convert.ToInt32(Session["TA_TahvilType"]) == 1)
{
DataLayer.AtsTotalNewDataContext context = new DataLayer.AtsTotalNewDataContext();
Sell.Contract.Report repo = new Sell.Contract.Report();
var TA_Recevier = Convert.ToInt32(Session["TA_Recevier"]);
var model = repo.GetGhateiDeliveredReport(1, Convert.ToInt32(Session["TA_RecevierType"]), "", Session["TA_FromDate"].ToString(), Session["TA_ToDate"].ToString(), TA_Recevier);
StiReport stireport2 = new StiReport();
stireport2.RegBusinessObject("AmaniDeliverdCar", model);
stireport2.Load(Server.MapPath("/Content/report/AmaniDeliverdCar.mrt"));
stireport2.Dictionary.Variables["FRomDate"].Value = BAL.StaticData.DateNow.Date;
stireport2.Dictionary.Variables["FromTime"].Value = BAL.StaticData.DateNow.Time;
return(StiMvcViewer.GetReportSnapshotResult(this.HttpContext, stireport2));
}
else
{
DataLayer.AtsTotalNewDataContext context = new DataLayer.AtsTotalNewDataContext();
Sell.Contract.Report repo = new Sell.Contract.Report();
var TA_Recevier = Convert.ToInt32(Session["TA_Recevier"]);
var model = repo.GetGhateiDeliveredReport(0, Convert.ToInt32(Session["TA_RecevierType"]), "", Session["TA_FromDate"].ToString(), Session["TA_ToDate"].ToString(), TA_Recevier);
StiReport stireport2 = new StiReport();
stireport2.RegBusinessObject("GhatiDeliveredReport", model);
stireport2.Load(Server.MapPath("/Content/report/ghatii.mrt"));
stireport2.Dictionary.Variables["FRomDate"].Value = BAL.StaticData.DateNow.Date;
//stireport2.Dictionary.Variables["FromTime"].Value = BAL.StaticData.DateNow.Time;
return(StiMvcViewer.GetReportSnapshotResult(this.HttpContext, stireport2));
}
}
public int Insert(LendingCarsDetailModel model)
{
int Id = 0;
DataLayer.AtsTotalNewDataContext context = new DataLayer.AtsTotalNewDataContext();
int F_IDrequstAmani = (int)model.F_IDrequstAmani;
int F_IDCar = (int)model.F_IDCar;
int AcceptanceType = (int)model.AcceptanceType;
int F_color = (int)model.F_color;
int num = (int)model.num;
int radif = (int)model.radif;
int Days = (int)model.Days;
int DelivType = (int)model.DelivType;
int F_Deliver = (int)model.F_Deliver;
string NameDeliv = model.NameDeliv;
int F_UsageType = model.F_UsageType;
string sql = @"DECLARE @Out int
EXEC [sale].[STP_T00050060];1
@F_IDrequstAmani ={0},
@F_IDCar ={1},
@AcceptanceType= {2},
@F_color ={3},
@num ={4},
@radif ={5},
@Days ={6},
@DelivType ={7},
@F_Deliver ={8},
@NameDeliv ={9},
@F_UsageType ={10},
@Out = @Out OUTPUT
SELECT @Out as N'@Out'";
Id = context.ExecuteQuery <int>(sql,
F_IDrequstAmani,
F_IDCar,
AcceptanceType,
F_color,
num,
radif,
Days,
DelivType,
F_Deliver,
NameDeliv,
F_UsageType).FirstOrDefault();
DataLayer.AtsTotalNewDataContext NewContext = new DataLayer.AtsTotalNewDataContext();
var query = (from t in NewContext.T00050060s
where t.IDDetailReqAmani == Id
select t).FirstOrDefault();
query.status = 801;
query.Statusdate = Core.StaticData.DateNow.Date;
query.StatusTime = Core.StaticData.DateNow.Time;
NewContext.SubmitChanges();
return(Id);
}
public Boolean DeleteByMaster(int IDrequstAmani)
{
Boolean Result = false;
DataLayer.AtsTotalNewDataContext context = new DataLayer.AtsTotalNewDataContext();
string sql = @"delete from T00050060 where IDDetailReqAmani=" + IDrequstAmani;
context.ExecuteCommand(sql);
//3
return(Result);
}
public List <LendingCarsFlowModel> GetLendingCarsFlow(int AGNID)
{
DataLayer.AtsTotalNewDataContext context = new DataLayer.AtsTotalNewDataContext();
var Result = context.ExecuteQuery <LendingCarsFlowModel>("execute sale.STP_T00050062;2");
if (BAL.StaticData.IsAgent)
{
//Result = Result.Where(p => p.AGNCode == AGNID);
}
return(Result.ToList());
}
public Boolean Delete(int LendingCarsId)
{
Boolean Result = false;
DataLayer.AtsTotalNewDataContext context = new DataLayer.AtsTotalNewDataContext();
string sql = @"update T00050060 set status=809
WHERE (f_IdrequstAmani = " + LendingCarsId + ")";
context.ExecuteCommand(sql);
return(Result);
}
public ActionResult Create(Sell.LendingCars.LendingCarsModel model)
{
try
{
Sell.LendingCars.LendingCars LendingCarsRepo = new Sell.LendingCars.LendingCars();
DataLayer.AtsTotalNewDataContext context = new DataLayer.AtsTotalNewDataContext();
if (!LendingCarsRepo.CheckForEdit(model.IDrequstAmani))
{
ResultType result = new ResultType();
result.Status = -1;
result.ReturnType = 1;
result.Message = "وضعیت درخواست تغییر کرده و امکان ویرایش درخواست وجود ندارد ";
return(Json(result, JsonRequestBehavior.AllowGet));
}
if (model.IDrequstAmani == 0)
{
var id = LendingCarsRepo.Insert(model);
var Code = context.T00050061s.Where(p => p.IDrequstAmani == id).FirstOrDefault().code;
ResultType result = new ResultType();
result.Status = 0;
result.ReturnType = 1;
result.Message = "درخواست امانی ثبت شد";
result.Parameters = new List <Tuple <string, string> >();
result.Parameters.Add(new Tuple <string, string>("Id", id.ToString()));
result.Parameters.Add(new Tuple <string, string>("Code", Code));
return(Json(result, JsonRequestBehavior.AllowGet));
}
else
{
LendingCarsRepo.Update(model);
//edit contract
ResultType result = new ResultType();
result.Parameters = new List <Tuple <string, string> >();
result.Parameters.Add(new Tuple <string, string>("Id", model.IDrequstAmani.ToString()));
result.Parameters.Add(new Tuple <string, string>("Code", model.code));
result.Status = 0;
result.ReturnType = 1;
result.Message = "درخواست امانی ویرایش شد";
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
ResultType result = new ResultType();
result.Status = 0;
result.ReturnType = 1;
result.Message = ex.Message;
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
public List <LendingCarsDetailViewModel> GetByAmaniID(int AmaniID)
{
DataLayer.AtsTotalNewDataContext context = new DataLayer.AtsTotalNewDataContext();
var Result = context.ExecuteQuery <LendingCarsDetailViewModel>("execute sale.STP_T00050060;4 " + AmaniID + ",0,0,0").ToList();;
foreach (var record in Result)
{
var query = (from t in context.T00050060s
where t.IDDetailReqAmani == record.IDDetailReqAmani
select t).FirstOrDefault();
record.F_IDCar = query.F_IDCar;
}
return(Result);
}
public LendingCarsModel GetById(int id)
{
DataLayer.AtsTotalNewDataContext context = new DataLayer.AtsTotalNewDataContext();
LendingCarsModel model = new LendingCarsModel();
var query = (from t in context.T00050061s
where (t.IDrequstAmani == id)
select t).FirstOrDefault();
model.code = query.code;
model.DateA = query.DateA;
model.F_AgnID = query.F_AgnID;
model.FlgTaahod = Convert.ToBoolean(query.FlgTaahod);
model.TrackID = (int?)query.TrackID;
return(model);
}
public List <LendingCarsViewModel> GetAll(int AGNID, string code, string FromDate, string ToDate, int F_CarID, int F_color, int F_UsageType)
{
if (FromDate == "")
{
FromDate = "13 / / ";
}
if (ToDate == "")
{
ToDate = "13 / / ";
}
DataLayer.AtsTotalNewDataContext context = new DataLayer.AtsTotalNewDataContext();
var Result = context.ExecuteQuery <LendingCarsViewModel>("execute sale.STP_T00050061;10 " + AGNID + "," + code + ",'" + FromDate + "','" + ToDate + "'," + F_CarID + "," + F_color + "," + F_UsageType).ToList();
return(Result);
}
public List <System.Web.Mvc.SelectListItem> GetAllBarbariComboBox()
{
DataLayer.AtsTotalNewDataContext context = new DataLayer.AtsTotalNewDataContext();
var Result = new List <System.Web.Mvc.SelectListItem>();
Result = (from t in context.T00050064s
select new System.Web.Mvc.SelectListItem
{
Selected = false,
Text = t.Name,
Value = t.IdBarbary.ToString()
}).ToList();
Result.Add(new System.Web.Mvc.SelectListItem {
Selected = true, Text = "انتخاب کنید", Value = "0"
});
return(Result);
}
public Boolean CheckForEdit(int LendingCarsId)
{
Boolean Result = true;
DataLayer.AtsTotalNewDataContext context = new DataLayer.AtsTotalNewDataContext();
var Query = from t in context.T00050060s
where t.F_IDrequstAmani == LendingCarsId
select t;
foreach (var a in Query)
{
if (a.status != 801)
{
Result = false;
}
}
return(Result);
}
public List <System.Web.Mvc.SelectListItem> GetAllComboBox(int AGNID, string Name)
{
DataLayer.AtsTotalNewDataContext context = new DataLayer.AtsTotalNewDataContext();
var Result = new List <System.Web.Mvc.SelectListItem>();
if (BAL.StaticData.IsAgent)
{
var agnCode = BAL.StaticData.AgentCode;
var query = from t in context.T00050061s
join agent in context.T00050002s
on t.F_AgnID equals agent.AGNID
where t.F_AgnID == agnCode
select
new System.Web.Mvc.SelectListItem
{
Selected = false,
Text = t.code + "-" + t.DateA + "-" + agent.AGNDesc,
Value = t.IDrequstAmani.ToString()
};
Result = query.Where(p => p.Text.Contains(Name)).Take(20).ToList();
}
else
{
var query = from t in context.T00050061s
join agent in context.T00050002s
on t.F_AgnID equals agent.AGNID
select
new System.Web.Mvc.SelectListItem
{
Selected = false,
Text = t.code + "-" + t.DateA + "-" + agent.AGNDesc,
Value = t.IDrequstAmani.ToString()
};
Result = query.Where(p => p.Text.Contains(Name)).Take(20).ToList();
}
if (Name == "")
{
Result.Add(new System.Web.Mvc.SelectListItem {
Selected = true, Text = "انتخاب کنید", Value = "0"
});
}
return(Result);
}
public List <System.Web.Mvc.SelectListItem> GetAllKargozranComboBox()
{
DataLayer.AtsTotalNewDataContext context = new DataLayer.AtsTotalNewDataContext();
var Result = new List <System.Web.Mvc.SelectListItem>();
var r = context.ExecuteQuery <KargozaranModel>("select * from ViwT0005_kargozaran").ToList();
foreach (var a in r)
{
Result.Add(new System.Web.Mvc.SelectListItem
{
Value = a.IDKargozar.ToString(),
Text = a.FullName,
Selected = false
});
}
Result.Add(new System.Web.Mvc.SelectListItem {
Selected = true, Text = "انتخاب کنید", Value = "0"
});
return(Result);
}
public JsonResult ContractDetailFillCombosNotSaved(string DetailItem)
{
DataLayer.AtsTotalNewDataContext context = new DataLayer.AtsTotalNewDataContext();
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
var model = serializer.Deserialize <Sell.LendingCars.LendingCarsDetailViewSModel>(DetailItem);
var ProductUsage = new Sell.Products.Products().GetProductUsageByProductTypeId((int)model.F_IDCar).Where(p => p.F_pyprmtflID == model.F_UsageType).FirstOrDefault();
var ProductType = context.T00050016s.Where(p => p.CarId == (int)model.F_IDCar).FirstOrDefault();
var Delivery = new Sell.Agents.Agents().GetByID((int)model.F_Deliver);
var ProductGroup = context.T00020002s.Where(p => p.pyprmtflID == ProductType.CarGroup).FirstOrDefault();
return(Json(new
{
ProductGroup = ProductGroup.pt_desc,
ProductType = ProductType.CarName,
ProductUsage = (ProductUsage == null) ? "انتخاب کنید" : ProductUsage.pt_desc,
DeliveryAddress = Delivery.Agent_AGNDesc,
ProductGroupId = ProductType.CarGroup,
ProductTypeId = ProductType.CarId,
ProductUsageId = (ProductUsage == null) ? 0 : model.F_UsageType,
DeliveryAddressId = model.F_Deliver,
}, JsonRequestBehavior.AllowGet));
}
public Boolean Update(LendingCarsModel model)
{
Boolean Result = false;
DataLayer.AtsTotalNewDataContext context = new DataLayer.AtsTotalNewDataContext();
string DateA = model.DateA;
int F_AgnID = (int)model.F_AgnID;
int? FlgTaahod = (model.FlgTaahod == true) ? 1 : 0;
int IDrequstAmani = model.IDrequstAmani;
string sql = @"EXEC [sale].[STP_T00050061];2
@IDrequstAmani ={0},
@DateA ={1},
@F_AgnID= {2},
@FlgTaahod ={3}" ;
context.ExecuteCommand(sql,
IDrequstAmani,
DateA,
F_AgnID,
FlgTaahod);
return(Result);
}
public ActionResult Delete(int id)
{
try
{
Sell.LendingCars.LendingCars LendingCarsRepo = new Sell.LendingCars.LendingCars();
DataLayer.AtsTotalNewDataContext context = new DataLayer.AtsTotalNewDataContext();
LendingCarsRepo.Delete(id);
ResultType result = new ResultType();
result.Status = 0;
result.ReturnType = 1;
result.Message = "درخواست ابطال شد";
return(Json(result, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
ResultType result = new ResultType();
result.Status = 0;
result.ReturnType = 1;
result.Message = ex.Message;
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
