protected void ImgAssignCatalog_Click(object sender, ImageClickEventArgs e)
{
try
{
string cell = "1";
string cell1 = "1";
using (BLL_PURC_Purchase objTechService = new BLL_PURC_Purchase())
{
//foreach (GridDataItem selectedItem1 in grdVessel.SelectedItems)
//{
//GridDataItem row1 = (GridDataItem)selectedItem1;// to access the selected row
// cell1 = row1["Vessel_code"].Text;
cell1 = DDLVessel.SelectedValue.ToString();
foreach (GridDataItem selectedItem in grdAssignLocation.SelectedItems)
{
GridDataItem row = (GridDataItem)selectedItem; // to access the selected row
cell = row["code"].Text;
foreach (GridDataItem item in grdunAsigncatalog.SelectedItems)
{
AssignVesselData objAssignVesselDataDO = new AssignVesselData();
GridDataItem rowItem = (GridDataItem)item; // to access the selected row
string cellItem = rowItem["system_Code"].Text;
objAssignVesselDataDO.Vessel_code = cell1;
objAssignVesselDataDO.LocationCode = cell;
objAssignVesselDataDO.Systemcode = cellItem;
objAssignVesselDataDO.LocationComments = "";
objAssignVesselDataDO.CurrentUser = Session["userid"].ToString();
int a = objTechService.VLassignLocation(objAssignVesselDataDO);
}
}
// }
bindCatalogLocation(cell, cell1);
}
//AddToSyncronizer.AddToSyncroNizerData("PURC_Dtl_Vessel_Locations");
}
catch (Exception ex)
{
//.WriteError(this.GetType().Name.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name.ToString(), ex);
}
finally
{
}
}
public int VLUnassignLocation(AssignVesselData objDOAssignVessel)
{
try
{
System.Data.SqlClient.SqlParameter[] obj = new System.Data.SqlClient.SqlParameter[]
{
new System.Data.SqlClient.SqlParameter("@Vessel_Code", objDOAssignVessel.Vessel_code),
new System.Data.SqlClient.SqlParameter("@Location_Code", objDOAssignVessel.LocationCode),
new System.Data.SqlClient.SqlParameter("@System_Code", objDOAssignVessel.Systemcode),
new System.Data.SqlClient.SqlParameter("@Location_Comments", objDOAssignVessel.LocationComments),
new System.Data.SqlClient.SqlParameter("@Created_By", objDOAssignVessel.CurrentUser)
};
return(SqlHelper.ExecuteNonQuery(_internalConnection, CommandType.StoredProcedure, "[PURC_SP_Ins_Vessel_Location]", obj));
}
catch (Exception ex)
{
throw ex;
}
}
public int VLUnassignLocation(AssignVesselData objDOAssignVessel)
{
return(objAssignVessel.VLUnassignLocation(objDOAssignVessel));
}
