// GET: Kanagata
public ActionResult KanagataEntry(KanagataModel kgmodel)
{
if (string.IsNullOrWhiteSpace(kgmodel.Mode))
{
kgmodel.Mode = "New";
}
return(View(kgmodel));
}
public string M_Casting_ExistsCheck(KanagataModel kgmodel)
{
BaseDL bdl = new BaseDL();
kgmodel.Sqlprms = new SqlParameter[1];
kgmodel.Sqlprms[0] = new SqlParameter("@CastingCD", SqlDbType.VarChar)
{
Value = (object)kgmodel.CastingCD ?? DBNull.Value
};
return(bdl.SelectJson("M_Casting_ExistsCheck", kgmodel.Sqlprms));
}
public string M_BrandName_Select(KanagataModel kgmodel)
{
BaseDL bdl = new BaseDL();
kgmodel.Sqlprms = new SqlParameter[1];
kgmodel.Sqlprms[0] = new SqlParameter("@BrandCD", SqlDbType.VarChar)
{
Value = (object)kgmodel.BrandCD ?? DBNull.Value
};
return(bdl.SelectJson("M_BrandName_Select", kgmodel.Sqlprms));
}
public string M_Casting_ExistsCheck([FromBody] KanagataModel kgmodel)
{
Kanagata_BL kgbl = new Kanagata_BL();
return(kgbl.M_Casting_ExistsCheck(kgmodel));
}
public string M_BrandName_Select([FromBody] KanagataModel kgmodel)
{
Kanagata_BL kgbl = new Kanagata_BL();
return(kgbl.M_BrandName_Select(kgmodel));
}
public string Casting_CUD([FromBody] KanagataModel kgmodel)
{
Kanagata_BL kgbl = new Kanagata_BL();
return(kgbl.Casting_CUD(kgmodel));
}
public string Casting_CUD(KanagataModel kgmodel)
{
BaseDL bdl = new BaseDL();
if (kgmodel.Mode.Equals("New"))
{
kgmodel.SPName = "M_Casting_Insert";
kgmodel.Sqlprms = new SqlParameter[5];
kgmodel.Sqlprms[0] = new SqlParameter("@CastingCD", SqlDbType.VarChar)
{
Value = kgmodel.CastingCD
};
kgmodel.Sqlprms[1] = new SqlParameter("@CastingName", SqlDbType.VarChar)
{
Value = kgmodel.CastingName
};
kgmodel.Sqlprms[2] = new SqlParameter("@BrandCD", SqlDbType.VarChar)
{
Value = kgmodel.BrandCD
};
kgmodel.Sqlprms[3] = new SqlParameter("@BrandName", SqlDbType.VarChar)
{
Value = kgmodel.BrandName
};
kgmodel.Sqlprms[4] = new SqlParameter("@UseLimit", SqlDbType.VarChar)
{
Value = kgmodel.UseLimit
};
}
else if (kgmodel.Mode.Equals("Edit"))
{
kgmodel.SPName = "M_Casting_Update";
kgmodel.Sqlprms = new SqlParameter[5];
kgmodel.Sqlprms[0] = new SqlParameter("@CastingCD", SqlDbType.VarChar)
{
Value = kgmodel.CastingCD
};
kgmodel.Sqlprms[1] = new SqlParameter("@CastingName", SqlDbType.VarChar)
{
Value = kgmodel.CastingName
};
kgmodel.Sqlprms[2] = new SqlParameter("@BrandCD", SqlDbType.VarChar)
{
Value = kgmodel.BrandCD
};
kgmodel.Sqlprms[3] = new SqlParameter("@BrandName", SqlDbType.VarChar)
{
Value = kgmodel.BrandName
};
kgmodel.Sqlprms[4] = new SqlParameter("@UseLimit", SqlDbType.VarChar)
{
Value = kgmodel.UseLimit
};
}
else if (kgmodel.Mode.Equals("Delete"))
{
kgmodel.SPName = "M_Casting_Delete";
kgmodel.Sqlprms = new SqlParameter[1];
kgmodel.Sqlprms[0] = new SqlParameter("@CastingCD", SqlDbType.VarChar)
{
Value = kgmodel.CastingCD
};
//kgmodel.Sqlprms[1] = new SqlParameter("@CastingName", SqlDbType.VarChar) { Value = kgmodel.CastingName };
//kgmodel.Sqlprms[2] = new SqlParameter("@BrandCD", SqlDbType.VarChar) { Value = kgmodel.BrandCD };
//kgmodel.Sqlprms[3] = new SqlParameter("@BrandName", SqlDbType.VarChar) { Value = kgmodel.BrandName };
//kgmodel.Sqlprms[4] = new SqlParameter("@UseLimit", SqlDbType.VarChar) { Value = kgmodel.UseLimit };
}
return(bdl.SelectJson(kgmodel.SPName, kgmodel.Sqlprms));
}
