public HttpResponseMessage Save(Entities.WareHousing.TransferIn ti) { if (ti.ID > 0) { return(Request.CreateResponse(HttpStatusCode.OK, ti.Update())); } else { return(Request.CreateResponse(HttpStatusCode.OK, ti.Save())); } }
/// <summary> /// Retrieve single entry from the list /// </summary> /// <param name="Id">Id of that particular entry you want retrieve</param> /// <param name="LocationId">Location id of that particular entry</param> /// <returns>single transfer in details</returns> public static TransferIn GetDetails(int Id, int LocationId) { DBManager db = new DBManager(); try { string query = @"select tr.Transfer_In_Id,isnull(tr.From_Location,0)[From_Location],isnull(tr.Entry_Date,0)[Entry_Date], isnull(tr.Total_Tax_Amount,0)[Tot_Tax_Amount],isnull(tr.Total_Gross_Amount,0)[Tot_Gross_Amount], isnull(tr.Total_Net_Amount,0)[Tot_Net_Amount],isnull(tr.Entry_No,0)[Entry_No], isnull(tr.Status,0)[Status],td.Tid_Id,td.Tod_Id,td.item_id,td.Instance_Id,isnull(td.Quantity,0)[Quantity],isnull(td.Mrp,0)[Mrp], isnull(td.Rate,0)[Rate],isnull(td.Selling_Price,0)[Selling_Price],isnull(td.Tax_Amount,0)[Tax_Amount],td.Tax_Id, isnull(td.Gross_Amount,0)[Gross_Amount], isnull(td.Status,0)[Status],td.Net_Amount,isnull(t.Percentage,0)[Tax_Percentage],l.Name[Location],isnull(i.Name,0)[Item], isnull(i.Item_Code,0)[Item_Code],tr.Cost_Center_Id,j.Job_Id,cost.Fcc_Name[Cost_Center],j.Job_Name, l.name[Location],l.Address1[Loc_Address1],l.Address2[Loc_Address2],l.Contact[Loc_Phone],l.Reg_Id1[Loc_RegId],tr.Terms_And_Conditions from TBL_TRANSFER_IN_REGISTER tr left join TBL_TRANSFER_IN_DETAILS td on td.Transfer_In_Id=tr.Transfer_In_Id left join TBL_TAX_MST t on t.Tax_Id=td.Tax_Id left join TBL_LOCATION_MST l on l.Location_Id=tr.From_Location left join tbl_item_mst i on i.item_Id=td.Item_Id left join tbl_Fin_CostCenter cost on cost.Fcc_ID=tr.Cost_Center_Id left join TBL_JOB_MST j on j.Job_Id=tr.Job_Id where tr.From_Location=@Location_Id and tr.Transfer_In_Id=@Transfer_In_Id order by tr.Created_Date desc"; db.CreateParameters(2); db.AddParameters(0, "@Location_Id", LocationId); db.AddParameters(1, "@Transfer_In_Id", Id); db.Open(); DataTable dt = db.ExecuteQuery(CommandType.Text, query); if (dt != null) { DataRow row = dt.Rows[0]; TransferIn register = new TransferIn(); register.ID = row["Transfer_In_Id"] != DBNull.Value ? Convert.ToInt32(row["Transfer_In_Id"]) : 0; register.CostCenterId = row["Cost_Center_Id"] != DBNull.Value ? Convert.ToInt32(row["Cost_Center_Id"]) : 0; register.JobId = row["Job_Id"] != DBNull.Value ? Convert.ToInt32(row["Job_Id"]) : 0; register.FromLocation = row["From_Location"] != DBNull.Value ? Convert.ToInt32(row["From_Location"]) : 0; register.EntryDateString = row["Entry_Date"] != DBNull.Value ? Convert.ToDateTime(row["Entry_Date"]).ToString("dd/MMM/yyyy") : string.Empty; register.TaxAmount = row["Tot_Tax_Amount"] != DBNull.Value ? Convert.ToDecimal(row["Tot_Tax_Amount"]) : 0; register.Gross = row["Tot_Gross_Amount"] != DBNull.Value ? Convert.ToDecimal(row["Tot_Gross_Amount"]) : 0; register.NetAmount = row["Tot_Net_Amount"] != DBNull.Value ? Convert.ToDecimal(row["Tot_Net_Amount"]) : 0; register.EntryNo = Convert.ToString(row["Entry_No"]); register.Location = Convert.ToString(row["Location"]); register.LocationAddress1 = Convert.ToString(row["Loc_Address1"]); register.LocationAddress2 = Convert.ToString(row["Loc_Address2"]); register.LocationPhone = Convert.ToString(row["Loc_Phone"]); register.LocationRegId = Convert.ToString(row["Loc_RegId"]); register.TermsAndConditions = Convert.ToString(row["Terms_And_Conditions"]); register.Status = row["Status"] != DBNull.Value ? Convert.ToInt32(row["Status"]) : 0; DataTable inProducts = dt.AsEnumerable().Where(x => x.Field <int>("Transfer_In_Id") == register.ID).CopyToDataTable(); List <Item> products = new List <Item>(); for (int j = 0; j < inProducts.Rows.Count; j++) { DataRow rowItem = inProducts.Rows[j]; Item item = new Item(); item.DetailsID = rowItem["Tid_Id"] != DBNull.Value ? Convert.ToInt32(rowItem["Tid_Id"]) : 0; item.InstanceId = rowItem["instance_id"] != DBNull.Value ? Convert.ToInt32(rowItem["instance_id"]) : 0; item.TodId = rowItem["Tod_Id"] != DBNull.Value ? Convert.ToInt32(rowItem["Tod_Id"]) : 0; item.ItemID = rowItem["item_id"] != DBNull.Value ? Convert.ToInt32(rowItem["item_id"]) : 0; item.Name = rowItem["Item"].ToString(); item.MRP = rowItem["Mrp"] != DBNull.Value ? Convert.ToDecimal(rowItem["Mrp"]) : 0; item.CostPrice = rowItem["Rate"] != DBNull.Value ? Convert.ToDecimal(rowItem["Rate"]) : 0; item.SellingPrice = rowItem["Selling_Price"] != DBNull.Value ? Convert.ToDecimal(rowItem["Selling_Price"]) : 0; item.TaxPercentage = rowItem["Tax_Percentage"] != DBNull.Value ? Convert.ToDecimal(rowItem["Tax_Percentage"]) : 0; item.Gross = rowItem["Gross_Amount"] != DBNull.Value ? Convert.ToDecimal(rowItem["Gross_Amount"]) : 0; item.NetAmount = rowItem["Net_Amount"] != DBNull.Value ? Convert.ToDecimal(rowItem["Net_Amount"]) : 0; item.TaxAmount = rowItem["Tax_Amount"] != DBNull.Value ? Convert.ToDecimal(rowItem["Tax_Amount"]) : 0; item.Quantity = rowItem["Quantity"] != DBNull.Value ? Convert.ToDecimal(rowItem["Quantity"]) : 0; item.ItemCode = Convert.ToString(rowItem["Item_Code"]); products.Add(item); dt.Rows.RemoveAt(0); } register.Products = products; return(register); } return(null); } catch (Exception ex) { Application.Helper.LogException(ex, "TransferIn |GetDetails(int Id,int LocationId)"); return(null); } }