/// <summary>
/// Insert additional items in workshop request item details table (WorkShopRequestItem table)
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int InsertAdditionalWorkshopRequestItem(WorkShopRequestItem model, IDbConnection connection, IDbTransaction txn)
{
try
{
string query = @"INSERT INTO WorkShopRequestItem(
WorkShopRequestId,
Slno,
ItemId,
Remarks,
Quantity,
isActive)
VALUES(
@WorkShopRequestId,
@Slno,
@ItemId,
@Remarks,
@Quantity,
1);
SELECT CAST(SCOPE_IDENTITY() AS INT)";
return(connection.Query <int>(query, model, txn).First());
}
catch (Exception)
{
throw;
}
}
public int UpdateWorkShopRequestItem(WorkShopRequestItem objWorkShopRequestItem)
{
using (IDbConnection connection = OpenConnection(dataConnection))
{
string sql = @"Update WorkShopRequestItem Set WorkShopRequestItemRefNo=@WorkShopRequestItemRefNo,WorkShopRequestItemName=@WorkShopRequestItemName OUTPUT INSERTED.WorkShopRequestItemId WHERE WorkShopRequestItemId=@WorkShopRequestItemId";
var id = connection.Execute(sql, objWorkShopRequestItem);
return(id);
}
}
public int InsertWorkShopRequestAdditionalMaterial(WorkShopRequestItem model, IDbConnection connection, IDbTransaction trn)
{
try
{
string sql = @"INSERT INTO WorkShopRequestItem (WorkShopRequestId,ItemId,Remarks,Quantity,isActive,isAddtionalMaterialRequest) VALUES( @WorkShopRequestId ,@ItemId,@Remarks,@Quantity,1,1);
SELECT CAST(SCOPE_IDENTITY() as int)";
var id = connection.Query <int>(sql, model, trn).Single();
return(id);
}
catch (Exception)
{
throw;
}
}
public ActionResult Print(int Id)
{
ReportDocument rd = new ReportDocument();
rd.Load(Path.Combine(Server.MapPath("~/Reports"), "WorkShopRequest.rpt"));
DataSet ds = new DataSet();
ds.Tables.Add("Head");
ds.Tables.Add("Items");
//-------HEAD
ds.Tables["Head"].Columns.Add("WorkShopRequestRefNo");
ds.Tables["Head"].Columns.Add("WorkShopRequestDate");
ds.Tables["Head"].Columns.Add("CustomerName");
ds.Tables["Head"].Columns.Add("CustomerOrderRef");
ds.Tables["Head"].Columns.Add("SaleOrderRefNo");
ds.Tables["Head"].Columns.Add("EDateArrival");
ds.Tables["Head"].Columns.Add("EDateDelivery");
ds.Tables["Head"].Columns.Add("WorkDescription");
ds.Tables["Head"].Columns.Add("SpecialRemarks");
ds.Tables["Head"].Columns.Add("RequiredDate");
ds.Tables["Head"].Columns.Add("DoorNo");
ds.Tables["Head"].Columns.Add("Street");
ds.Tables["Head"].Columns.Add("State");
ds.Tables["Head"].Columns.Add("CountryName");
ds.Tables["Head"].Columns.Add("Zip");
ds.Tables["Head"].Columns.Add("Fax");
ds.Tables["Head"].Columns.Add("Email");
ds.Tables["Head"].Columns.Add("Phone");
ds.Tables["Head"].Columns.Add("OrganizationName");
ds.Tables["Head"].Columns.Add("Image1");
ds.Tables["Head"].Columns.Add("Title");
//-------DT
ds.Tables["Items"].Columns.Add("ItemName");
ds.Tables["Items"].Columns.Add("PartNo");
ds.Tables["Items"].Columns.Add("Remarks");
ds.Tables["Items"].Columns.Add("Quantity");
ds.Tables["Items"].Columns.Add("UnitName");
WorkShopRequestRepository repo = new WorkShopRequestRepository();
var Head = repo.GetWorkshopRequestHdDataPrint(Id, OrganizationId);
DataRow dr = ds.Tables["Head"].NewRow();
dr["WorkShopRequestRefNo"] = Head.WorkShopRequestRefNo;
dr["WorkShopRequestDate"] = Head.WorkShopRequestDate.ToString("dd-MMM-yyyy");
dr["CustomerName"] = Head.CustomerName;
dr["CustomerOrderRef"] = Head.CustomerOrderRef;
dr["SaleOrderRefNo"] = Head.SaleOrderRefNo;
dr["EDateArrival"] = Head.EDateArrival.ToString("dd-MMM-yyyy");
dr["EDateDelivery"] = Head.EDateDelivery.ToString("dd-MMM-yyyy");
dr["WorkDescription"] = Head.WorkDescription;
dr["SpecialRemarks"] = Head.SpecialRemarks;
dr["Title"] = Head.title;
dr["RequiredDate"] = Head.RequiredDate.ToString("dd-MMM-yyyy");
dr["DoorNo"] = Head.DoorNo;
dr["Street"] = Head.Street;
dr["State"] = Head.State;
dr["CountryName"] = Head.CountryName;
dr["Zip"] = Head.Zip;
dr["Fax"] = Head.Fax;
dr["Email"] = Head.Email;
dr["Phone"] = Head.Phone;
dr["OrganizationName"] = Head.OrganizationName;
dr["Image1"] = Server.MapPath("~/App_images/") + Head.Image1;
ds.Tables["Head"].Rows.Add(dr);
WorkShopRequestRepository repo1 = new WorkShopRequestRepository();
var Items = repo1.GetWorkShopRequestDtDataPrint(Id);
foreach (var item in Items)
{
var pritem = new WorkShopRequestItem
{
ItemName = item.ItemName,
PartNo = item.PartNo,
Remarks = item.Remarks,
Quantity = item.Quantity,
UnitName = item.UnitName,
};
DataRow dri = ds.Tables["Items"].NewRow();
dri["ItemName"] = pritem.ItemName;
dri["PartNo"] = pritem.PartNo;
dri["Remarks"] = pritem.Remarks;
dri["Quantity"] = pritem.Quantity;
dri["UnitName"] = pritem.UnitName;
ds.Tables["Items"].Rows.Add(dri);
}
ds.WriteXml(Path.Combine(Server.MapPath("~/XML"), "WorkShopRequest.xml"), XmlWriteMode.WriteSchema);
rd.SetDataSource(ds);
Response.Buffer = false;
Response.ClearContent();
Response.ClearHeaders();
try
{
Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, SeekOrigin.Begin);
return(File(stream, "application/pdf"));//, String.Format("WorkShopRequest{0}.pdf", Id.ToString()));
}
catch (Exception ex)
{
throw;
}
}
