public bool DeleteFeatureCharacteristicsDetails(decimal operationCode, string featurCode, decimal sno = 0)
{
if (!operationCode.IsNotNullOrEmpty() || !featurCode.IsNotNullOrEmpty() || !sno.IsNotNullOrEmpty())
{
return(false);
}
FEATURE_MASTER featureMast = new FEATURE_MASTER();
try
{
featureMast = (from c in DB.FEATURE_MASTER
where c.OPER_CODE == operationCode && c.FEATURE_CODE == featurCode && c.SNO == sno
select c).FirstOrDefault <FEATURE_MASTER>();
if (featureMast != null)
{
featureMast.DELETE_FLAG = true;
featureMast.UPDATED_DATE = DateTime.Now;
featureMast.UPDATED_BY = userInformation.UserName;
DB.SubmitChanges();
}
return(true);
}
catch (Exception ex)
{
DB.FEATURE_MASTER.Context.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, featureMast);
ex.LogException();
return(false);
}
//return false;
}
public bool SaveFeatureCodeMaster(DataView dgvCharacterstic, string operCode, string operDesc, string featureCode, string featureDesc, ref string type)
{
FEATURE_MASTER featureMastUpdate = new FEATURE_MASTER();
try
{
DataView dgvCharactersticFSave;
decimal sampleSize = 0;
dgvCharactersticFSave = dgvCharacterstic.ToTable().Copy().DefaultView;
List <FEATURE_MASTER> lstexistingDatas = new List <FEATURE_MASTER>();
lstexistingDatas = ((from c in DB.FEATURE_MASTER
where c.OPER_CODE == Convert.ToDecimal(operCode.Trim()) && c.FEATURE_CODE == featureCode
select c).ToList());
if (lstexistingDatas.Count > 0)
{
DB.FEATURE_MASTER.DeleteAllOnSubmit(lstexistingDatas);
DB.SubmitChanges();
}
int rown = 1;
dgvCharactersticFSave.RowFilter = "MEASURING_TECHNIQUE is not null or SAMPLE_SIZE is not null or SAMPLE_FREQUENCY is not null or CONTROL_METHOD is not null or REACTION_PLAN is not null";
if (dgvCharactersticFSave.Count > 0)
{
try
{
for (int i = 0; i < dgvCharactersticFSave.Count; i++)
{
if (dgvCharactersticFSave[i][5].ToString().Trim().Length == 0)
{
sampleSize = 0;
}
else
{
sampleSize = Convert.ToDecimal(dgvCharactersticFSave[i][5].ToString());
}
featureMastUpdate = new FEATURE_MASTER()
{
OPER_CODE = Convert.ToDecimal(operCode.Trim()),
FEATURE_CODE = featureCode,
FEATURE_DESC = featureDesc,
SNO = rown,
MEASURING_TECHNIQUE = dgvCharactersticFSave[i][4].ToString(),
SAMPLE_SIZE = sampleSize,
SAMPLE_FREQUENCY = dgvCharactersticFSave[i][6].ToString(),
CONTROL_METHOD = dgvCharactersticFSave[i][7].ToString(),
REACTION_PLAN = dgvCharactersticFSave[i][8].ToString(),
ROWID = Guid.NewGuid()
};
rown = rown + 1;
DB.FEATURE_MASTER.InsertOnSubmit(featureMastUpdate);
DB.SubmitChanges();
type = "INS";
}
return(true);
}
catch (Exception ex)
{
ex.LogException();
DB.FEATURE_MASTER.DeleteOnSubmit(featureMastUpdate);
}
}
//if (ExtendedMethods.IsNotNullOrEmpty(dgvCharactersticFSave) && dgvCharactersticFSave.Count > 0) dgvCharactersticFSave.RowFilter = "MEASURING_TECHNIQUE is not null ";
//Existing Codes Update
// dgvCharactersticFUpdate = dgvCharacterstic.ToTable().Copy().DefaultView;
// if (ExtendedMethods.IsNotNullOrEmpty(dgvCharactersticFUpdate) && dgvCharactersticFUpdate.Count > 0) dgvCharactersticFUpdate.RowFilter = "feature_code is not null";
// if (dgvCharactersticFUpdate.Count > 0)
// {
// for (int i = 0; i < dgvCharactersticFUpdate.Count; i++)
// {
// if (dgvCharactersticFUpdate[i][5].ToString().Trim().Length == 0)
// {
// sampleSize = 0;
// }
// else
// {
// sampleSize = Convert.ToDecimal(dgvCharactersticFUpdate[i][5].ToString());
// }
// featureMastUpdate = (from c in DB.FEATURE_MASTER
// where c.OPER_CODE == Convert.ToDecimal(operCode.Trim()) && c.SNO == Convert.ToDecimal(dgvCharactersticFUpdate[i]["SNO"].ToString()) && c.FEATURE_CODE == dgvCharactersticFUpdate[i]["FEATURE_CODE"].ToString()
// select c).FirstOrDefault<FEATURE_MASTER>();
// if (featureMastUpdate.IsNotNullOrEmpty())
// {
// try
// {
// featureMastUpdate.FEATURE_DESC = featureDesc;
// featureMastUpdate.FEATURE_CODE = featureCode;
// featureMastUpdate.OPER_CODE = Convert.ToDecimal(operCode.Trim());
// featureMastUpdate.MEASURING_TECHNIQUE = dgvCharactersticFSave[i][4].ToString();
// featureMastUpdate.SAMPLE_SIZE = sampleSize;
// featureMastUpdate.SAMPLE_FREQUENCY = dgvCharactersticFSave[i][6].ToString();
// featureMastUpdate.CONTROL_METHOD = dgvCharactersticFSave[i][7].ToString();
// featureMastUpdate.REACTION_PLAN = dgvCharactersticFSave[i][8].ToString();
// DB.SubmitChanges();
// type = "UPD";
// }
// catch (Exception ex)
// {
// DB.FEATURE_MASTER.Context.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, featureMastUpdate);
// }
// }
// }
// }
// sampleSize = 0;
// if (ExtendedMethods.IsNotNullOrEmpty(dgvCharactersticFSave) && dgvCharactersticFSave.Count > 0) dgvCharactersticFSave.RowFilter = "MEASURING_TECHNIQUE is not null or SAMPLE_SIZE is not null or SAMPLE_FREQUENCY is not null or CONTROL_METHOD is not null or REACTION_PLAN is not null";
// rowCount = dgvCharactersticFSave.Count;
// if (ExtendedMethods.IsNotNullOrEmpty(dgvCharactersticFSave) && dgvCharactersticFSave.Count > 0) dgvCharactersticFSave.RowFilter = "(MEASURING_TECHNIQUE is not null or SAMPLE_SIZE is not null or SAMPLE_FREQUENCY is not null or CONTROL_METHOD is not null or REACTION_PLAN is not null) and feature_code is null";
// if (operCode == "") operCode = "0";
// rowCount = rowCount - dgvCharactersticFSave.Count;
// if (dgvCharactersticFSave.Count == 0)
// {
// featureMastUpdate = (from c in DB.FEATURE_MASTER
// where c.FEATURE_CODE == featureCode
// select c).FirstOrDefault<FEATURE_MASTER>();
// if (featureMastUpdate.IsNotNullOrEmpty())
// {
// try
// {
// // featureMastUpdate.FEATURE_CODE = featureCode;
// featureMastUpdate.FEATURE_DESC = featureDesc;
// DB.SubmitChanges();
// }
// catch (Exception)
// {
// DB.FEATURE_MASTER.Context.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, featureMastUpdate);
// }
// }
// return true;
// }
// if (dgvCharactersticFSave.Count > 0)
// {
// try
// {
// for (int i = 0; i < dgvCharactersticFSave.Count; i++)
// {
// if (dgvCharactersticFSave[i][5].ToString().Trim().Length == 0)
// {
// sampleSize = 0;
// }
// else
// {
// sampleSize = Convert.ToDecimal(dgvCharactersticFSave[i][5].ToString());
// }
// featureMastUpdate = new FEATURE_MASTER()
// {
// OPER_CODE = Convert.ToDecimal(operCode.Trim()),
// FEATURE_CODE = featureCode,
// FEATURE_DESC = featureDesc,
// SNO = rowCount + 1,
// MEASURING_TECHNIQUE = dgvCharactersticFSave[i][4].ToString(),
// SAMPLE_SIZE = sampleSize,
// SAMPLE_FREQUENCY = dgvCharactersticFSave[i][6].ToString(),
// CONTROL_METHOD = dgvCharactersticFSave[i][7].ToString(),
// REACTION_PLAN = dgvCharactersticFSave[i][8].ToString(),
// ROWID = Guid.NewGuid()
// };
// rowCount = featureMastUpdate.SNO;
// DB.FEATURE_MASTER.InsertOnSubmit(featureMastUpdate);
// DB.SubmitChanges();
// type = "INS";
// }
// return true;
// }
// catch (Exception)
// {
// DB.FEATURE_MASTER.DeleteOnSubmit(featureMastUpdate);
// }
// }
}
catch (Exception ex)
{
// DB.FEATURE_MASTER.Context.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, featureMastUpdate);
Dal.RollBackTransaction();
throw ex.LogException();
}
return(false);
}