public int Delete(Int64 HeadId)
{
//clsAccountPosting objclsAccountPosting = new clsAccountPosting();
int value = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
TyreIssHead qth = db.TyreIssHeads.Where(h => h.MatIss_Idno == HeadId).FirstOrDefault();
List <Stckdetl> ObjStckDetl = db.Stckdetls.Where(h => h.MtrlIssue_Idno == HeadId).ToList();
List <TyreIssDetl> qtd = db.TyreIssDetls.Where(d => d.MatIssHead_Idno == HeadId).ToList();
if (qth != null && ObjStckDetl != null)
{
foreach (var d in qtd)
{
db.TyreIssDetls.DeleteObject(d);
db.SaveChanges();
}
foreach (var b in ObjStckDetl)
{
b.MtrlIssue_Idno = 0;
b.Is_Issued = false;
db.SaveChanges();
}
db.TyreIssHeads.DeleteObject(qth);
db.SaveChanges();
value = 1;
}
}
return(value);
}
private void PrintMaterial(TyreIssHead MatHead, object Matdetl)
{
Repeater obj = new Repeater();
double dcmsn = 0, dblty = 0, dcrtge = 0, dsuchge = 0, dwges = 0, dPF = 0, dtax = 0, dtoll = 0, dqty = 0, damnt = 0, dweight = 0;
string CompName = ""; string Add1 = "", Add2 = ""; string PhNo = ""; string City = ""; string State = ""; string PanNo; string TinNo = ""; string Serv_No = ""; string Through = ""; string FaxNo = ""; string Remark = ""; string DelNoteRef = "";
int iPrintOption, PrintRcptAmnt = 0; string strTermCond = ""; Int32 PriPrinted = 0; Int32 ReportTyp = 0; int compID = 0; string numbertoent = "";
DataSet CompDetl = SqlHelper.ExecuteDataset(ApplicationFunction.ConnectionString(), CommandType.Text, "select * from tblcompmast");
# region Company Details
public void Populate(Int32 intMatIdNo)
{
TyreIssueDAL obj = new TyreIssueDAL();
TyreIssHead objMatHead = obj.SelectMatHead(intMatIdNo);
var objMatDetl = obj.SelectMatDetail(intMatIdNo);
hidGRHeadIdno.Value = Convert.ToString(intMatIdNo);
if (objMatHead != null)
{
ddlDateRange.SelectedValue = Convert.ToString(objMatHead.Year_Idno);
txtGRDate.Text = string.IsNullOrEmpty(Convert.ToString(objMatHead.MatIss_Date)) ? "" : Convert.ToDateTime(objMatHead.MatIss_Date).ToString("dd-MM-yyyy");
iGrAgainst = Convert.ToInt32(objMatHead.MatIss_Typ);
// RDbDirect.Enabled = false; RDbRecpt.Enabled = false;
//new
txtRemarkhead.Text = string.IsNullOrEmpty(Convert.ToString(objMatHead.ReMark)) ? "" : Convert.ToString(objMatHead.ReMark);
txtGRNo.Text = string.IsNullOrEmpty(Convert.ToString(objMatHead.MatIss_No)) ? "" : Convert.ToString(objMatHead.MatIss_No);
ddlTruckNo.SelectedValue = string.IsNullOrEmpty(Convert.ToString(objMatHead.Truck_Idno)) ? "0" : Convert.ToString(objMatHead.Truck_Idno);
ddlTruckNo_SelectedIndexChanged(null, null);
ddlDriver.SelectedValue = string.IsNullOrEmpty(Convert.ToString(objMatHead.Driver_Idno)) ? "0" : Convert.ToString(objMatHead.Driver_Idno);
ddlReciver.SelectedValue = string.IsNullOrEmpty(Convert.ToString(objMatHead.Driver_Idno)) ? "0" : Convert.ToString(objMatHead.Driver_Idno);
ddlLocation.SelectedValue = string.IsNullOrEmpty(Convert.ToString(objMatHead.Loc_Idno)) ? "0" : Convert.ToString(objMatHead.Loc_Idno);
dtTemp = CreateDt();
for (int counter = 0; counter < objMatDetl.Count; counter++)
{
string strItemName = Convert.ToString(DataBinder.Eval(objMatDetl[counter], "Item_Name"));
string strItemNameId = Convert.ToString(DataBinder.Eval(objMatDetl[counter], "Iteam_Idno"));
string strQty = Convert.ToString(DataBinder.Eval(objMatDetl[counter], "Item_Qty"));
string strWeight = Convert.ToString(DataBinder.Eval(objMatDetl[counter], "Item_Weght"));
string strRate = Convert.ToString(DataBinder.Eval(objMatDetl[counter], "Item_Rate"));
string strAmount = Convert.ToString(DataBinder.Eval(objMatDetl[counter], "Item_Amnt"));
string strDetail = Convert.ToString(DataBinder.Eval(objMatDetl[counter], "Remark"));
string strStckdetlNO = Convert.ToString(DataBinder.Eval(objMatDetl[counter], "SerialNo"));
string strStckdetl_Idno = Convert.ToString(DataBinder.Eval(objMatDetl[counter], "SerlDetl_id"));
ApplicationFunction.DatatableAddRow(dtTemp, counter + 1, strItemName, strItemNameId, strQty, strWeight, strRate, strAmount, strDetail, strStckdetlNO, strStckdetl_Idno);
}
ViewState["dt"] = dtTemp;
BindGridT();
txtNetAmnt.Text = string.IsNullOrEmpty(Convert.ToString(objMatHead.Net_Amnt)) ? "0" : String.Format("{0:0,0.00}", objMatHead.Net_Amnt);
PrintMaterial(objMatHead, objMatDetl);
}
obj = null;
}
public Int64 MatUpdate(Int64 intGRIdno, DateTime?dtMat_Date, Int32 IAgainst, Int64 intMat_No, Int32 intLoc_Idno, Int32 TruckNoIdno, Double DNetAmnt, Int32 YearIdno, DataTable dtDetail, Int32 intIssueTo, string strRemark, Int64 DriverIdno)
{
Int64 intGrIdno = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
try
{
TyreIssHead objGRHead = db.TyreIssHeads.Where(rh => (rh.MatIss_Idno != intGRIdno) && (rh.MatIss_No == intMat_No) && (rh.Loc_Idno == intLoc_Idno) && (rh.Year_Idno == YearIdno)).FirstOrDefault();
if (objGRHead == null)
{
TyreIssHead objMatIssHead1 = db.TyreIssHeads.Where(rh => rh.MatIss_Idno == intGRIdno).FirstOrDefault();
if (objMatIssHead1 != null)
{
objMatIssHead1.MatIss_Date = dtMat_Date;
objMatIssHead1.MatIss_Typ = IAgainst;
objMatIssHead1.MatIss_No = intMat_No;
objMatIssHead1.Loc_Idno = intLoc_Idno;
objMatIssHead1.Truck_Idno = TruckNoIdno;
objMatIssHead1.Net_Amnt = DNetAmnt;
objMatIssHead1.Year_Idno = YearIdno;
objMatIssHead1.Issue_To = intIssueTo;
objMatIssHead1.ReMark = strRemark;
objMatIssHead1.Date_Modified = System.DateTime.Now;
objMatIssHead1.Mat_Frm = "BK";
objMatIssHead1.Driver_Idno = DriverIdno;
db.SaveChanges();
intGrIdno = objMatIssHead1.MatIss_Idno;
if (intGrIdno > 0)
{
List <TyreIssDetl> lstGrDetl = db.TyreIssDetls.Where(obj => obj.MatIssHead_Idno == intGrIdno).ToList();
if (lstGrDetl.Count > 0)
{
foreach (TyreIssDetl obj in lstGrDetl)
{
db.TyreIssDetls.DeleteObject(obj);
}
db.SaveChanges();
}
List <Stckdetl> ObjStckDetl = db.Stckdetls.Where(h => h.MtrlIssue_Idno == intGrIdno).ToList();
if (ObjStckDetl != null)
{
foreach (var b in ObjStckDetl)
{
b.MtrlIssue_Idno = 0;
b.Is_Issued = false;
db.SaveChanges();
}
}
foreach (DataRow row in dtDetail.Rows)
{
Int64 StckDetlIdno = Convert.ToInt64(row["StckDetl_Idno"]);
Stckdetl objStckDetl = db.Stckdetls.Where(r => r.SerlDetl_id == StckDetlIdno).SingleOrDefault();
objStckDetl.MtrlIssue_Idno = Convert.ToInt64(intGrIdno);
objStckDetl.Is_Issued = true;
TyreIssDetl objMatIssDetl = new TyreIssDetl();
objMatIssDetl.MatIssHead_Idno = Convert.ToInt64(intGrIdno);
objMatIssDetl.Iteam_Idno = Convert.ToInt32(row["Item_Idno"]);
objMatIssDetl.Item_Qty = Convert.ToInt64(row["Quantity"]);
objMatIssDetl.Item_Weght = Convert.ToDouble(row["Weight"]);
objMatIssDetl.Item_Rate = Convert.ToDouble(row["Rate"]);
objMatIssDetl.Item_Amnt = Convert.ToDouble(row["Amount"]);
objMatIssDetl.Remark = Convert.ToString(row["Detail"]);
objMatIssDetl.StckDetl_Idno = Convert.ToInt64(row["StckDetl_Idno"]);
db.TyreIssDetls.AddObject(objMatIssDetl);
db.SaveChanges();
}
}
}
}
else
{
intGrIdno = -1;
}
}
catch (Exception Ex)
{
intGrIdno = 0;
}
}
return(intGrIdno);
}
public Int64 InsertMat(DateTime?dtMat_Date, Int32 IAgainst, Int64 intMat_No, Int32 intLoc_Idno, Int32 TruckNoIdno, Double DNetAmnt, Int32 YearIdno, DataTable dtDetail, Int32 intIssueTo, string strRemark, Int64 DriverIdno)
{
Int64 intMateIdno = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
try
{
TyreIssHead objMatHead = db.TyreIssHeads.Where(rh => (rh.MatIss_No == intMat_No) && (rh.Loc_Idno == intLoc_Idno) && (rh.Year_Idno == YearIdno)).FirstOrDefault();
if (objMatHead == null)
{
objMatHead = new TyreIssHead();
objMatHead.MatIss_Date = dtMat_Date;
objMatHead.MatIss_Typ = IAgainst;
objMatHead.MatIss_No = intMat_No;
objMatHead.Loc_Idno = intLoc_Idno;
objMatHead.Truck_Idno = TruckNoIdno;
objMatHead.Net_Amnt = DNetAmnt;
objMatHead.Year_Idno = YearIdno;
objMatHead.Issue_To = intIssueTo;
objMatHead.ReMark = strRemark;
objMatHead.Date_Added = System.DateTime.Now;
objMatHead.Mat_Frm = "BK";
objMatHead.Driver_Idno = DriverIdno;
db.TyreIssHeads.AddObject(objMatHead);
db.SaveChanges();
intMateIdno = objMatHead.MatIss_Idno;
if (intMateIdno > 0)
{
foreach (DataRow row in dtDetail.Rows)
{
Int64 StckDetlIdno = Convert.ToInt64(row["StckDetl_Idno"]);
Stckdetl objStckDetl = db.Stckdetls.Where(r => r.SerlDetl_id == StckDetlIdno).SingleOrDefault();
objStckDetl.MtrlIssue_Idno = Convert.ToInt64(intMateIdno);
objStckDetl.Is_Issued = true;
TyreIssDetl objMatDetl = new TyreIssDetl();
objMatDetl.MatIssHead_Idno = Convert.ToInt64(intMateIdno);
objMatDetl.Iteam_Idno = Convert.ToInt32(row["Item_Idno"]);
objMatDetl.Item_Qty = Convert.ToInt64(row["Quantity"]);
objMatDetl.Item_Weght = Convert.ToDouble(row["Weight"]);
objMatDetl.Item_Rate = Convert.ToDouble(row["Rate"]);
objMatDetl.Item_Amnt = Convert.ToDouble(row["Amount"]);
objMatDetl.Remark = Convert.ToString(row["Detail"]);
objMatDetl.StckDetl_Idno = Convert.ToInt64(row["StckDetl_Idno"]);
db.TyreIssDetls.AddObject(objMatDetl);
db.SaveChanges();
}
// tScope.Complete();
}
}
else
{
intMateIdno = -1;
}
}
catch (Exception Ex)
{
intMateIdno = 0;
}
}
return(intMateIdno);
}
