private DataTable CreateDt()
{
DataTable dttemp = ApplicationFunction.CreateTable("tbl", "Gr_Idno", "String", "Gr_No", "String", "Gr_Date", "String", "Recivr_Idno", "String", "GR_From", "String", "To_City", "String", "From_City", "String",
"Amount", "String", "Tot_Recvd", "String", "cur_Bal", "String", "Recv_Amount", "String");
return(dttemp);
}
private DataTable CreateDt()//Chln_Idno,Chln_No,Chln_Date,Fromcity_Idno,Truck_Idno,Driver_Idno,Challan_Amnt,Recvd_Amnt
{
DataTable dttemp = ApplicationFunction.CreateTable("tbl", "Chln_Idno", "String", "Chln_No", "String", "Chln_Date", "String", "Fromcity_Idno", "String", "Truck_Idno", "String", "Driver_Idno", "String",
"Challan_Amnt", "String", "Recvd_Amnt", "String");
return(dttemp);
}
private DataTable CreateDt()
{
DataTable dttemp = ApplicationFunction.CreateTable("tblMain",
"Id", "String",
"SerialIdno", "String");
return(dttemp);
}
public DataTable ReadExcelFile(string fileName)
{
string msg = string.Empty;
DataTable dt = new DataTable();
string filepath = Server.MapPath(fileName);
string constring = string.Empty;
if (System.IO.Path.GetExtension(filepath) == ".xls")
{
constring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" + filepath + "';Extended Properties='Excel 8.0;HDR=Yes;'";
}
else if (System.IO.Path.GetExtension(filepath) == ".xlsx")
{
constring = "Provider= Microsoft.ACE.OLEDB.12.0;OLE DB Services=-4;Data Source='" + filepath + "'; Extended Properties=\"Excel 12.0;HDR=YES;\"";
}
if (string.IsNullOrEmpty(constring) == false)
{
OleDbConnection con = new OleDbConnection(constring);
con.Open();
DataTable ExcelTable = new DataTable();
ExcelTable = con.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
string SheetName = Convert.ToString(ExcelTable.Rows[0][2]);
OleDbDataAdapter da = new OleDbDataAdapter("select * from [" + SheetName + "]", con);
DataSet ds = new DataSet();
da.Fill(ds);
dt = ApplicationFunction.CreateTable("tblOpngStckAccessoriesFromExcel", "Item", "String", "Qty", "String", "Rate", "String");
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Columns[0].Caption == "Item" && ds.Tables[0].Columns[1].Caption == "Qty" && ds.Tables[0].Columns[2].Caption == "Rate")
{
if (ds.Tables[0].Rows.Count > 0)
{
for (int count = 0; count < ds.Tables[0].Rows.Count; count++)
{
ApplicationFunction.DatatableAddRow(dt,
Convert.ToString(ds.Tables[0].Rows[count]["Item"]),
Convert.ToString(ds.Tables[0].Rows[count]["Qty"]),
Convert.ToString(ds.Tables[0].Rows[count]["Rate"])
);
}
}
else
{
ShowMessageErr("Excel Is Blank.Please Upload With Data.");
}
}
else
{
this.ShowMessageErr("Excel Header Not In Correct Format.");
}
}
else
{
ShowMessageErr("Please Check Excel File Columns!");
}
}
return(dt);
}
private DataTable CreateDt()
{
DataTable dttemp = ApplicationFunction.CreateTable("tblMain",
"Id", "String",
"SerialIdno", "String",
"SbillIdno", "String",
"DefectRemark", "String",
"VechAppDetails", "String");
return(dttemp);
}
private DataTable CreateDt()
{
DataTable dttemp = ApplicationFunction.CreateTable("tbl",
"Id", "String",
"DocName", "String",
"Remark", "String",
"Image", "String"
);
return(dttemp);
}
private DataTable CreateDivDt()
{
DataTable temp = ApplicationFunction.CreateTable("tbl",
"Id", "String",
"HeadIdno", "String",
"HeadDate", "String",
"ClaimNo", "String",
"PrtyName", "String",
"FromCityName", "String",
"CompName", "String");
return(temp);
}
private DataTable CreateDivDt()
{
DataTable temp = ApplicationFunction.CreateTable("tbl",
"Id", "String",
"SerialIdno", "String",
"SerialNo", "String",
"SbillIdno", "String",
"SBillNo", "String",
"SBillDate", "String",
"CityName", "String",
"PartyName", "String",
"PartyIdno", "String");
return(temp);
}
private DataTable CreateDt()
{
DataTable dttemp = ApplicationFunction.CreateTable("tbl",
"Id", "String",
"YearIdno", "String",
"LocIdno", "String",
"LocName", "String",
"ItemIdno", "String",
"ItemName", "String",
"Qty", "String",
"Rate", "String"
);
return(dttemp);
}
private DataTable CreateDt()
{
DataTable dttemp = ApplicationFunction.CreateTable("tbl",
"id", "String",
"City_FIdno", "String",
"City_FName", "String",
"Lorry_Idno", "String",
"Lorry_Type", "String",
"Rate_Date", "String",
"ToCity_Idno", "String",
"City_Name", "String",
"Item_Rate", "String"
);
return(dttemp);
}
private DataTable CreateDt()
{
DataTable dttemp = ApplicationFunction.CreateTable("tbl",
"Id", "String",
"Item_Name", "String",
"Item_Idno", "String",
"Quantity", "String",
"Weight", "String",
"Rate", "String",
"Amount", "String",
"Detail", "String",
"StckDetl_No", "String",
"StckDetl_Idno", "String"
);
return(dttemp);
}
private DataTable CreateDt()
{
DataTable dttemp = ApplicationFunction.CreateTable("tbl",
"Id", "String",
"SerialNo", "String",
"CompName", "String",
"TypeId", "String",
"Type", "String",
"PurFrom", "String",
"OpenRate", "String",
"TyreName", "String",
"TyreIdno", "String",
"SerialIdno", "String",
"TyreSize", "String",
"TyreSizeIdno", "String"
);
return(dttemp);
}
private DataTable CreateDt()
{
DataTable dttemp = ApplicationFunction.CreateTable("tbl",
"Id", "String",
"FromCity", "String",
"ToCity", "String",
"Leg", "String",
"ETA", "String",
"ATA", "String",
"ETD", "String",
"ATD", "String",
"TAT_in_hrs", "String",
"Delay_in_hrs", "String",
"Remarks", "String",
"FromCityIdno", "String",
"ToCityIdno", "String"
);
return(dttemp);
}
private DataTable CreateDt()
{
DataTable dttemp = ApplicationFunction.CreateTable("tbl",
"Id", "String",
"GR_No", "String",
"GR_Date", "String",
"Gr_Type", "String",
"Gr_TypeIdno", "String",
"FromCity", "String",
"FromCityIdno", "String",
"ToCity", "String",
"ToCityIdno", "String",
"SenderName", "String",
"SenderNameIdno", "String",
"ReciverName", "String",
"ReciverNameIdno", "String",
"Qty", "String",
"Weight", "String",
"Amount", "String",
"Detail", "String"
);
return(dttemp);
}
private DataTable CreateDt()
{
DataTable dttemp = ApplicationFunction.CreateTable("tbl", "id", "String", "Sumry_No", "String", "Recvng_Date", "String", "Recvng_Amnt", "String", "Remark", "String");
return(dttemp);
}
private void BindGrid()
{
try
{
LostAlignRepDAL obj = new LostAlignRepDAL();
Int64 LorryIdno = (Convert.ToString(drpLorryNo.SelectedValue) == "" ? 0 : Convert.ToInt64(drpLorryNo.SelectedValue));
var DsGrdetail = obj.SelectForSearch(Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateFrom.Text)), Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateTo.Text)), LorryIdno);
if ((DsGrdetail != null) && (DsGrdetail.Count > 0))
{
grdMain.DataSource = DsGrdetail;
grdMain.DataBind();
DataTable dttemp1 = ApplicationFunction.CreateTable("tbl",
"SrNo", "String",
"Date", "String",
"LorryNo", "String",
"ItemName", "String",
"SerialNo", "String",
"PrevAlignDate", "String",
"AlignDate", "String"
);
for (int i = 0; i < DsGrdetail.Count; i++)
{
DataRow dr = dttemp1.NewRow();
dr["SrNo"] = Convert.ToString(i + 1);
dr["Date"] = Convert.ToString(Convert.ToDateTime(DataBinder.Eval(DsGrdetail[i], "Date")).ToString("dd-MM-yyyy"));
dr["LorryNo"] = Convert.ToString(DataBinder.Eval(DsGrdetail[i], "LorryNo"));
dr["ItemName"] = Convert.ToString(DataBinder.Eval(DsGrdetail[i], "ItemName"));
dr["SerialNo"] = Convert.ToString(DataBinder.Eval(DsGrdetail[i], "SerialNo"));
dr["PrevAlignDate"] = Convert.ToString(Convert.ToDateTime(DataBinder.Eval(DsGrdetail[i], "PrevAlignDate")).ToString("dd-MM-yyyy"));
dr["AlignDate"] = Convert.ToString(Convert.ToDateTime(DataBinder.Eval(DsGrdetail[i], "AlignDate")).ToString("dd-MM-yyyy"));
dttemp1.Rows.Add(dr);
}
ViewState["dtCSV"] = dttemp1;
int startRowOnPage = (grdMain.PageIndex * grdMain.PageSize) + 1;
int lastRowOnPage = startRowOnPage + grdMain.Rows.Count - 1;
lblcontant.Text = "Showing " + startRowOnPage.ToString() + " - " + lastRowOnPage.ToString() + " of " + DsGrdetail.Count.ToString();
lblcontant.Visible = true;
divpaging.Visible = true;
imgBtnExcel.Visible = true;
lblTotalRecord.Text = "T. Record(s) :" + Convert.ToString(DsGrdetail.Count);
}
else
{
grdMain.DataSource = null;
grdMain.DataBind();
lblTotalRecord.Text = "T. Record (s): 0 ";
imgBtnExcel.Visible = false;
}
}
catch (Exception Ex)
{
throw (Ex);
}
}
private void BindGrid()
{
try
{
DateTime?dtDateFrom = null;
DateTime?dtDateTo = null;
if (string.IsNullOrEmpty(txtDateFrom.Text.Trim()) == false)
{
dtDateFrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateFrom.Text.Trim()));
}
if (string.IsNullOrEmpty(txtDateTo.Text.Trim()) == false)
{
dtDateTo = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateTo.Text.Trim()));
}
StockTransferDAL objStck = new StockTransferDAL();
DataTable DsGrdetail = new DataTable();
var detail = objStck.SelectStckTransferReport(dtDateFrom, dtDateTo, Convert.ToInt32(ddlIssLoc.SelectedValue), Convert.ToInt32(ddlRecLoc.SelectedValue), Convert.ToInt32(drpItemName.SelectedValue), string.IsNullOrEmpty(drpSerialNo.SelectedValue) ? 0 : Convert.ToInt32(drpSerialNo.SelectedValue));
if (detail != null && detail.Count > 0)
{
grdMain.DataSource = detail;
grdMain.DataBind();
DataTable dttemp1 = ApplicationFunction.CreateTable("tbl",
"SrNo", "String",
"IssueNo", "String",
"IssueDate", "String",
"IssLoc", "String",
"RecLoc", "String",
"ItemName", "String",
"ItemType", "String",
"SerialNo", "String",
"Qty", "String",
"Rate", "String",
"Amount", "String"
);
for (int i = 0; i < detail.Count; i++)
{
DataRow dr = dttemp1.NewRow();
dr["SrNo"] = Convert.ToString(i + 1);
dr["IssueNo"] = Convert.ToString(DataBinder.Eval(detail[i], "StckTrans_No"));
dr["IssueDate"] = Convert.ToString(Convert.ToDateTime(DataBinder.Eval(detail[i], "StckTrans_Date")).ToString("dd-MM-yyyy"));
dr["IssLoc"] = Convert.ToString(DataBinder.Eval(detail[i], "IssLoc"));
dr["RecLoc"] = Convert.ToString(DataBinder.Eval(detail[i], "RecLoc"));
dr["ItemName"] = Convert.ToString(DataBinder.Eval(detail[i], "ItemName"));
dr["ItemType"] = Convert.ToString(DataBinder.Eval(detail[i], "ItemType"));
dr["SerialNo"] = Convert.ToString(DataBinder.Eval(detail[i], "SerialNo"));
dr["Qty"] = Convert.ToString(DataBinder.Eval(detail[i], "Qty"));
dr["Rate"] = Convert.ToString(DataBinder.Eval(detail[i], "Rate"));
dr["Amount"] = Convert.ToString(DataBinder.Eval(detail[i], "Tot_Amnt"));
dttemp1.Rows.Add(dr);
}
ViewState["dtCSV"] = dttemp1;
int startRowOnPage = (grdMain.PageIndex * grdMain.PageSize) + 1;
int lastRowOnPage = startRowOnPage + grdMain.Rows.Count - 1;
lblcontant.Text = "Showing " + startRowOnPage.ToString() + " - " + lastRowOnPage.ToString() + " of " + detail.Count.ToString();
lblcontant.Visible = true;
divpaging.Visible = true;
imgBtnExcel.Visible = true;
lblTotalRecord.Text = "T. Record(s) :" + Convert.ToString(detail.Count);
}
else
{
grdMain.DataSource = null; lblcontant.Visible = false;
grdMain.DataBind();
lblTotalRecord.Text = "T. Record (s): 0 ";
imgBtnExcel.Visible = false;
}
}
catch (Exception Ex)
{
throw (Ex);
}
}
private DataTable CreateDt()
{
DataTable DtTemp = ApplicationFunction.CreateTable("tbl", "SerialNo", "String", "CompanyName", "String", "LoctionName", "String", "ItemName", "String", "Qty", "String", "Rate", "String", "Amount", "String");
return(DtTemp);
}
private DataTable CreateDt()
{
DataTable dttemp = ApplicationFunction.CreateTable("tbl", "Gr_Idno", "String", "Item_Idno", "String", "Unit_Idno", "String", "Rate_Type", "String", "Qty", "String", "Weight", "String", "Amount", "String", "Delv_Qty", "String", "Delv_Wt", "String", "Delv_Amount", "String", "Reamrk", "String");
return(dttemp);
}
private DataTable CreateDt()
{
DtTemp = ApplicationFunction.CreateTable("tbl", "GrDetl_Idno", "String", "Gr_Idno", "String", "Item_Idno", "String", "Unit_Idno", "String", "Rate_Type", "String", "Qty", "String", "Weight", "String", "Amount", "String");
return(DtTemp);
}
private DataTable CreateDt()
{
DataTable DtTemp = ApplicationFunction.CreateTable("tbl", "Lorry_No", "String", "LicDate", "String", "RC", "String", "FitDate", "String", "Insurance", "String");
return(DtTemp);
}
private DataTable CreateDt()
{
DataTable dttemp = ApplicationFunction.CreateTable("tbl", "Id", "String", "Tocity_Idno", "String", "City_Name", "String", "Comision_Amnt", "String");
return(dttemp);
}
